VBA-selection a range of rows

  • Thread starter Thread starter Edward
  • Start date Start date
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...
 
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?
 
Back
Top