| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why won't this work? Syntacs?
I am trying to do a copy and paste using cell information instead of
just ranges because I want to later do a for loop so it's easier. When I run this it errors and highlights the Cells part. I tried to not use the cell command and it works fine by just doing....Range(A2:C2). Please help. ActiveSheet.Range(Cells(2, 1), Cells(2, 2), Cells(2, 3)).Copy <------ error ActiveSheet.Paste Destination:=Worksheets("Sheet1").Range("c1:e1") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to update a column in a work based on another work sheet | New Users to Excel | |||
| how can i automatically generate work order numbers from work orde | Excel Discussion (Misc queries) | |||
| If I have a work sheet protected and try to run a macro to hide rows or columns it won't work. Correct? | Excel Programming | |||
| Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
| Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
Threaded Mode
