Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple Copy-Paste logic not working
Here is my block of code.
<<< Dim ws As Worksheet Dim rowId as Integer Set ws = ThisWorkbook.Worksheets("Sheet1") For rowId = 1 to 10 ws.Range(Cells(rowId, 1), Cells(rowId, 2)).Copy _ ws.Range(Cells(rowId, 1), Cells(rowId, 2)).Offset(1, 0) '[fails at this step!!!] Next rowId <<< It works on my machine at home... but fails on my work computer. Both machines are XP Pro SP2 with Office 2003 installed. The error I get is : Runtime error 1004 - Method 'Range' of object '_Worksheet' failed I've seen the problem before, but can't remember what/why it doesn't work. Any help would be greatly appreciated. Brian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line copy - Not just a simple copy paste | Excel Worksheet Functions | |||
Simple Copy and Paste | Excel Programming | |||
Simple Copy & Paste | Excel Programming | |||
Help! What's wrong with this simple copy and paste | Excel Programming | |||
Simple copy and paste | Excel Programming |