Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The following code generates an error in Line 5
Sheets("APR").Select Rows("9:9").Select Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove Sheets("Data").Select Rows("25:25").Select ' Line 5 - Error happens here Selection.Copy Sheets("APR").Select ActiveSheet.Paste The error code is 400. The error description is "Select method of Range class failed". I'm not sure why this error is occurring, especially since the above code was generated by Excel's "Record Macro" function. Why would the above code work during "Record Macro", but it generates an error when I run it from VBA code? I basically have a button on my "APR" spreadsheet that calls the above code. Anybody know what's going on here? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Select method of Range class failed error message | Excel Programming | |||
error - select method failed - (columns.select) | Excel Programming | |||
Excel VBA error - Select method of Range class failed | Excel Programming | |||
Error: method 'select' of object_worksheet' failed | Excel Discussion (Misc queries) | |||
RT Error 1004, Select method of worksheet class failed | Excel Programming |