Posted to microsoft.public.excel.programming

external usenet poster

Posts: 51

Determining if a named range exists

Bob,

Thanks!

Anita

Bob Phillips wrote:

Sub RangeNameTes()
Dim rng As Range

On Error Resume Next
Set rng = Range("myRangeNAme")
On Error GoTo 0
If Not rng Is Nothing Then
' it exists
Else
' it doesn't exist
End If

End Sub

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
Validate Named Range Exists	John Jost	Excel Programming	5	December 5th 05 08:17 PM
Determining whether a named textbox on a chart exists	P. Dua-Brown	Excel Programming	4	October 20th 05 03:31 PM
how to tell if a named range exists	Gixxer_J_97[_2_]	Excel Programming	2	June 1st 05 07:38 PM
Determining if a Worksheet Exists	Chaplain Doug	Excel Programming	3	April 7th 05 10:00 PM
easy way to test if a Named Range exists	Andrew Bauer	Excel Programming	4	July 10th 03 07:32 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us