Search : in
By :

Copy cell to another sheet

Last answer on Nov 3, 2009 12:17:47 pm GMT mimic, on Nov 2, 2009 6:15:47 pm GMT 
 Report this message to moderators

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

Best answers for « Copy cell to another sheet » in :
Excel – Macro to detect and hide blank rows ShowExcel – Macro to detect and hide blank rows Issue Solution Note Issue I want a macro to unhide about 20 blank rows copy values into the top row then hide the remaining rows (some cells have fill though) then the next time it will...
Excel – Comparing cell A1 to entire A column in Sheet 2 ShowExcel – Comparing cell A1 to entire A column in Sheet 2 Issue Solution Note Issue I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row to a new sheet....
Excel - Send value of cell to target ShowExcel - Send value of cell to target Issue Solution Note Issue Is it possible to send the value of a cell (copy and paste special) to another cell where the value would not be disturbed when the source value changes to '0'? My...
Linux - The shell ShowIntroduction to the shell The command interpreter is the interface between the user and the operating system, hence the name "shell". The shell therefore acts as an intermediary between the operating system and the user thanks to command lines...
UNIX system - The shell ShowIntroduction to the shell The command interpreter is the interface between the user and the operating system, hence its name "shell". The shell therefore acts as an intermediary between the operating system and the user using command lines...

1

 LouisSteph, on Nov 3, 2009 12:17:47 pm GMT
  • +1

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.

Reply to LouisSteph