Hi
try the following (assumption: you have defined the name
'test_sect_name')
....
if intersect(Range("test_sect_name"),Range("A1")) is nothing then
msgbox "cell A1 not within name"
else
msgbox "cell A1 within name"
end if

--
Regards
Frank Kabel
Frankfurt, Germany

I have defined a named range. I want to use VBA Code to know whether
a
particular address from sheet is a member of the defined named range
or not ?

Thanks in advance.

Prasad Joshi


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