How do I select multiple rows by using VBA?

[Kenneth lEE]

How do I select multiple rows by using VBA? e.g. Row 2,4,6,8

Thanks so much

 

[Jay Freedman]

How do I select multiple rows by using VBA? e.g. Row 2,4,6,8

Thanks so much

In VBA, you can't select multiple pieces of text (rows or anything else)
that aren't continuous. See http://support.microsoft.com/?kbid=288424.

The best you can do is to select one piece at a time, working in a loop.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.