Ask your question
Message list Discussion Forum list

Copy cell to another sheet

mimic - Nov 2, 2009 6:15pm GMT - Last answer on Nov 3, 2009 12:17pm GMT LouisSteph
Report
Hello,

I'm have a problem. How can i copy a cell with its properties like cell border to another cell(ActiveCell) in a different sheet.

I need a function for it , like

Function CopyCell( R as Range) as Long


End Function

so i can call it from a cell like =CopyCell(sheet1!A1)

this would copy the cell value with its borders from cell A1 on sheet1 to the ActiveCell(the cell that is calling the function) on another Sheet.


Please help!Configuration: Windows XP Firefox 3.0.15
Read more ...

Plus de résultats pour :
Copy cell to another sheet»

I have an answer
Add comment

Kioskea recommends you to read :

VB code for copy data from one excel sheet toForumOffice software
Excel Macro Help Please [Solved]ForumOffice software
Copying data from one worksheet to anotherForumOffice software
Copying rows into a different sheet.ForumOffice software
Copy data onto sheet only if cell has textForumOffice software
Copy data into next empty cell in new sheetForumOffice software
Sort by :   Votes | Date | Date descending 1 answers
Best answer
+1
moins plus
LouisSteph 2269Posts September 28, 2009Registration date Nov 3, 2009 12:17pm GMT
Dear Mimic,

Please consider using the below sample to have the problem solved:

If Sheets("Sheet1"). Range("I5").Value = "Sample" Then _
Range("I5").EntireRow.Copy Destination:=Sheets("Complete").Range("A1")


Thanks in advance.

 Add comment - Permalink (1)
Add comment
Top
See also
supinfo