Many thanks to everyone for the responses; it looks like offset is the way to
go.

I really appreciate the examples, the code, and the explanations!

Thanks again,
Raul

P.S., I am continually amazed with the quality and the timeliness of the
responses to questions posted on this newsgroup. I cannot put into words
what a valuable asset this is to me and all the users of Microsoft products.


"Raul" wrote:

I have a number of named ranges in a workbook, and these ranges need to be
updated as new data is added. Is there a way to select all the named ranges
in a workbook and read the contents in the "refers to:" field? As an aside,
could these ranges be set up to be dynamic so they will update themselves to
fit the data?

Thanks in advance,
Raul