| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Expanding a named range | Excel Worksheet Functions | |||
| Expanding a range | Excel Programming | |||
| Using Query and expanding named ranges | Excel Discussion (Misc queries) | |||
| Named range not expanding with insertions after sort?? | Excel Programming | |||
| If any cell in named range = 8 then shade named range | Excel Programming | |||
Hybrid Mode
