Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying cells between sheets
Hi!
When I try to write this command in a macro : sheets("S1").range("A5:E5).copy (sheets("S2").range("A10:E20")) occurs an Error "Run-time error '1004': Impossible to execute the copy method in range class". It seems to me the copy command only works well when target sheet is the current sheet, I think... (It works when I try to copy to the sheet where the code is executed) :( Is there a way to do this? I need to copy the value and the format os the cells in the range... Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying cells between sheets in a workbook | Excel Discussion (Misc queries) | |||
copying text on sheet 1 to corresponding cells on sheets 2 to 5 | New Users to Excel | |||
HAVE ONE REPORT SHEET WITH LINKS FROM VARIOUS SHEETS. ON COPYING THIS LINKED SHEET FOR EXPORTING IT TO THE OFFICE GET ERRORS IN CELLS. HOW TO RESOLVE THIS? | Excel Programming | |||
copying the same cells from many sheets | Excel Worksheet Functions | |||
Macro copying cells between sheets | Excel Programming |