One way:
Worksheets("sheet1").Range("a5,a3,a1").EntireRow.S elect
Remember that you have to be on Sheet1 to select a range on sheet1.
And you can do most things without changing the selection.
TC wrote:
The following works:
Worksheets("Sheet1").Rows(5).Select
But if I want to select multiple nonadjacent rows how can I do that?
Worksheets("Sheet1").Rows(5,3,1).Select gives an error, quotes don't
work.
I could do this with Range but I'm curious if its possible with Rows.
Thanks for the help
--
Dave Peterson