Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The following gives this error, with "subscript out of range" message
When I select debug, it hi-lites the 3rd line. As far as I can see, this process is a direct copy from elsewhere in this ng. what am I missing? ' Copy formulas in G2 and I2 down thru to last used Row Dim lastrow As Long lastrow = Worksheets("Sheet1").Cells(Rows.Count, "A").End(xlUp).Row Range("G2").AutoFill Destination:=Range("G3:G" & lastrow) lastrow = Worksheets("Sheet1").Cells(Rows.Count, "A").End(xlUp).Row Range("I2").AutoFill Destination:=Range("I3:I" & lastrow) Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Conditional Formatting - Run Time Error '13' Type Mismatch Error | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming | |||
Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) | Excel Programming |