Posted to microsoft.public.excel.programming

Ian[_8_]

external usenet poster

Posts: 4

Selecting Named Ranges

I has a worksheet with approx 20 separate named ranges. I
wish to clear the contents of all these ranges through VBA
in the most efficient way.

Is there a way of selecting all the named ranges within a
specifc worksheet so that I can apply ClearContents to all
the ranges at once.

Thanks.

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
Index and named ranges selecting difficulty	Bruce Tharp	Excel Worksheet Functions	7	June 19th 07 02:49 AM
Selecting Multiple Columns in a Named Selection	Griffithpt	Excel Worksheet Functions	0	August 9th 06 10:54 PM
Like 123, allow named ranges, and print named ranges	WP	Excel Discussion (Misc queries)	1	April 8th 05 06:07 PM
Selecting Filtered Items from Named range	Soniya	Excel Programming	2	August 20th 03 10:59 AM
selecting ranges	MDC	Excel Programming	1	July 24th 03 03:34 PM

All times are GMT +1. The time now is 11:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us