Update Named Ranges
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
|