Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I increase the limit on the number of import rows in Excel | Excel Discussion (Misc queries) | |||
the limit on how many rows can be in one spreadsheet | Excel Worksheet Functions | |||
Increase rows in worksheet beyond 65,536 row limit | Excel Discussion (Misc queries) | |||
How do I limit number of rows and columns on a spreadsheet | New Users to Excel | |||
How do I limit the number of rows in an Excel worksheet. | Excel Worksheet Functions |