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

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

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

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