Posted to microsoft.public.excel.programming

TC[_6_]

external usenet poster

Posts: 10

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Is there a Filename property in PrintOut property	Christian[_6_]	Excel Programming	4	September 3rd 04 10:12 PM
VBA Question: going through rows in a sheet via vba	Mariam[_3_]	Excel Programming	1	June 24th 04 11:15 PM
Property question	Eric Bentzen	Excel Programming	1	August 5th 03 05:34 PM
Question about "End(xlUp)" property	Dave Peterson[_3_]	Excel Programming	1	August 4th 03 04:24 AM
Question about "End(xlUp)" property	Chip Pearson	Excel Programming	0	August 4th 03 02:57 AM

All times are GMT +1. The time now is 10:46 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us