Posted to microsoft.public.excel.programming

helen

external usenet poster

Posts: 105

selecting multiple ranges

I am working on a project where I need to perform multiple actions on a
selection of multiple ranges.

I am currently using :
Worksheets("Current Mth").Range(Cells(1, 2), Cells(2, C - 1))

Can I use something similar to the Range("a1:b1.V1:v4") format?

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
Selecting mutliple ranges	Scott Graft	Excel Worksheet Functions	4	June 13th 08 08:36 PM
Trouble with selecting multiple ranges of data	markag	Excel Worksheet Functions	2	June 23rd 06 04:35 PM
Selecting ranges	Steve Wood	Excel Programming	1	August 24th 04 02:16 PM
Selecting ranges with a text box	Bob Metzler	Excel Programming	0	September 22nd 03 04:47 PM
selecting ranges	MDC	Excel Programming	1	July 24th 03 03:34 PM

All times are GMT +1. The time now is 07:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us