Expanding a named range
 

Can anyone help me with coding an automated expansion of a named range
please? Here's my situation:

I have a range, 2 columns, 5 rows, which I set up as a named range.
When someone else enters information in the next row, it is not
automatically included in the named range. What I'm looking for is a
code that will automatically expand the named range to include the new
cells. It would probably look for the first blank row and stop just
prior to that blank row.

Any help is greatly appreciated!

Expanding a named range
 

Hi ?

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message oups.com...
Can anyone help me with coding an automated expansion of a named range
please? Here's my situation:

I have a range, 2 columns, 5 rows, which I set up as a named range.
When someone else enters information in the next row, it is not
automatically included in the named range. What I'm looking for is a
code that will automatically expand the named range to include the new
cells. It would probably look for the first blank row and stop just
prior to that blank row.

Any help is greatly appreciated!