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.

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.

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.

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.