We can thank Debra!

Biff

"John E." wrote in message
...
Thanks so much, Biff for this referral. This does what I want!
--
John E.


"Biff" wrote:

See this:

http://contextures.com/xlNames01.html#Dynamic

Biff

"John E." wrote in message
...
I am developing an Outlook solution in which we read a log that is an
Excel
spreadsheet that has a name range assigned to the data that is being
imported
into Outlook for a list box display. Outlook has the capability of
reading
the number of rows in an Excel named range and using that as a dynamic
way
to
read in continuously increasing data into an array that increases as
the
range increases. My problem is I don't want the Outlook user to have
to
go
to the spreadsheet log and readjust the name range everytime they use
Outlook. Is there any way to make the name range on a spreadsheet
dynamic
so the vertical range dimension grows as the number of rows grow in the
spreadsheet?
--
John E.