View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TC[_6_] TC[_6_] is offline
external usenet poster
 
Posts: 10
Default ROWS Property question

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