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.