Union over multiple sheets

Posted to microsoft.public.excel.programming

Randall

external usenet poster

Posts: 20

Union over multiple sheets

Is it possible to get a Union of ranges over multiple sheets? Something like:

Set RngA = Sheets(1).Range("A1:A5")
Set RngB = Sheets(2).Range("B2:B10")
Set Rng = Union(RngA, RngB)

The above code give a "Method 'Union' of object '_Global' failed" Error, ie
You can't Union ranges from multiple sheets. Does anyone know a workaround
to this?

Tx,
Randall

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
How to update data from multiple sheets to one specific sheets	Khawajaanwar	Excel Discussion (Misc queries)	4	January 15th 10 07:31 AM
Union or Join Sheets	Jeff C	Excel Discussion (Misc queries)	2	January 6th 09 06:16 PM
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA	Amaxwell	Excel Worksheet Functions	4	August 17th 06 06:23 AM
Union Method with multiple worksheets	Jeff B[_2_]	Excel Programming	3	September 29th 04 05:04 PM
Changing the value in multiple sheets without selecting those sheets	herm	Excel Programming	3	October 14th 03 03:50 PM

All times are GMT +1. The time now is 06:59 AM.

Menu

About Us