VBA-selection a range of rows

E

Edward

Hi everybody,
In VBA we can select a row in a table by
ActiveWindow.Selection.ShapeRange.Table.Rows(1).Select
my question is how can we select a range of rows at once like rows(1-10)
when I use a loop it deselects the previous row.
Thanks...
 
E

Edward

Thanks Steve,
..Select(msoFalse) dosen't work ( it generates wrong number of argument error)
The reason I thought selecting a range of rows would be useful is because I
work with large tables (over 100 rows ) so instead of deleting row by row
from a table I want to select a range of rows and delete them at once for
performance reasons( if possible).

We can select mutiple rows and columns either using mouse or keyboard in pp
so just as a curiosity , it's good to know how can this be done in VBA?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top