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
Bookmarks