| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete Rows Error Message
try this
Sheets("Group Lists").Rows("10401:13000").Delete Shift:=xlUp Sheets("index").Select -- Gary wrote in message oups.com... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete Rows Error Message
Try
Sheets("Group Lists").Range("10401:13000").EntireRow.Delete Shift:=xlUp Sheets("Index").Select -- Regards, Tom Ogilvy wrote in message oups.com... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete Rows Error Message
The code can be cleaned up if you want like this
Sheets("Group Lists").Rows("10401:13000").Delete Shift:=xlUp Sheets("Index").Select There will be a problem if the sheet is protected. Selects are rarely required and can cause difficulty. Let me know how it goes. -- HTH... Jim Thomlinson " wrote: 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 |
| Reply |
| 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 | |||
Hybrid Mode
