Posted to microsoft.public.excel.programming

external usenet poster

Posts: 13

How do i check if the a named range is empty

I have a named range ("Risks").
How can i check if this named range contains no values.
If the range is totaly empty, then i have to show a message box and exit the
sub.

Thanxxxxx,

Luc

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
Paste to next empty cell in named range of cells	Sully	Excel Discussion (Misc queries)	3	March 4th 10 05:23 PM
SUM() of empty dynamic named range returns #N/A	Aviashn	Excel Programming	2	June 2nd 08 08:52 PM
Trapping error from Empty Dynamic Named Range	Casey[_105_]	Excel Programming	5	June 13th 06 03:43 PM
Check for empty range in vba	Phil	Excel Discussion (Misc queries)	1	April 28th 06 09:57 PM
Named Range - Empty columns	Tempy	Excel Programming	8	July 8th 04 03:56 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us