|
|
|
|
#1
07-31-2012, 08:40 PM
|
||||
|
||||
Hi Eli,
It would be easier if you either: a) defined the largest possible range that will be required; or b) mark the last row in the range to indicate it shouldn't be used, then insert rows above that row as needed; or c) assign a name to the range, use the range name in the formula and redifine the named range as need be
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Change cell color everytime a value is selected in dropdown list | angelica_gloria | Excel | 4 | 01-27-2012 06:47 PM |
| Can a cell have a pop list? | malfromcessnock | Excel | 7 | 01-06-2012 07:34 AM |
 search a list while typing in a cell
|
virsojour | Excel | 1 | 07-08-2010 03:10 AM |
| Forms: combination of a list and a text field to be filled in | bart014 | Word | 0 | 04-23-2010 12:55 AM |
| Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |
Windows 7 64bit 
Office 2010 32bit
Hybrid Mode