Is there a limit on selecting individual rows in excel?
 

I am using VBA logic to set a variable holding a series of rows to be
deleted. When I use this on small worksheets no problem. But in larger
worksheets when the logic goes to "rangevariable.select" I get an error.
There are approx 168 rows selected in this occurance.

Just a guess...

You have to have the worksheet that contains that range selected before you can
select that range.

rangevariable.parent.parent.activate 'workbook
rangevariable.parent.select 'worksheet
rangevariable.select 'range

or just
application.goto rangvariable, scroll:=true

If that doesn't work, you may want to post more of the code.

drvmark wrote:

I am using VBA logic to set a variable holding a series of rows to be
deleted. When I use this on small worksheets no problem. But in larger
worksheets when the logic goes to "rangevariable.select" I get an error.
There are approx 168 rows selected in this occurance.

--

Dave Peterson