| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Rows Error Message
The following string...
Sheets("Group Lists").Select Rows("10401:13000").Select Selection.Delete Shift:=xlUp Sheets("Index").Select ....is returning the following error message... "Run-time error '1004': Select method of Range class failed" Is there a limit as to how many rows Excel will select? Reason I ask is...I do this exact string on a blank sheet and it works fine. Any help would be greatly appreciated. Kind Regards, Matt St.Onge Drafting & Estimating Manager Mankato Kasota Stone www.mankatokasotastone.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to delete rows giving mismatch error | Excel Discussion (Misc queries) | |||
| Getting error message when I try to insert rows. | Excel Discussion (Misc queries) | |||
| how do i prevent a #REF! error when i delete non adjacent rows? | Excel Worksheet Functions | |||
| Help Delete Rows based on the macro in this message | Excel Programming | |||
| Delete Key Error Message | Excel Programming | |||
Threaded Mode
