Posted to microsoft.public.excel.programming

Colo[_20_] Colo[_20_] is offline

external usenet poster

Posts: 1

Is there a "Non-Intersect" VBA method to remove a sub-range from a range?

Hi brettdj,

Here is Housaka's tips.
http://homepage2.nifty.com/housaka/excel/ununion.txt

Sub UnselectSelectedRange() may make sense.

---
Message posted from http://www.ExcelForum.com/

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
"Select method of Range class failed" Error	Ayo	Excel Discussion (Misc queries)	3	September 2nd 08 07:58 PM
Run-time error "1004" Select method of range class failed	Tallan	Excel Discussion (Misc queries)	3	March 7th 07 05:22 PM
Array as a "named range" - formula ok in cells, but error as "named range"	tskogstrom	Excel Discussion (Misc queries)	11	December 28th 06 04:44 PM
"Run-time error '1004'" Method 'Range' of object '_global' failed.	haisat[_2_]	Excel Programming	0	October 20th 03 12:13 PM

All times are GMT +1. The time now is 09:14 AM.

About Us

"It's about Microsoft Excel"