#1
|
|||
|
|||
change the definition of range name
I have a database with a range called "posted date". I want to add cells to the botom of that range and then change the definition of the range to include the new cells. How do I do this? |
#2
|
|||
|
|||
The most robust way would be to use the Format as Table functionality. Each column is implicitly identified as a range per the column header and the reference is automatically updated when records are added. If you would like help setting this up, attach your workbook here.
Otherwise, you can manually update the reference of named ranges with Formula:Name Manager. |
#3
|
|||
|
|||
OK, Thanks for the offer but I cannot attach the file. It is slsx
|
Tags |
range formula |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Acronym lister and definition checker for Microsoft Word | gwez | Word VBA | 1 | 06-13-2015 04:00 AM |
Lastrow definition problem | YounesB3 | Excel Programming | 1 | 09-26-2012 10:08 PM |
definition of work column | ketanco | Project | 9 | 05-31-2012 05:15 PM |
font in style definition trashed | eNGiNe | Word | 1 | 03-30-2012 05:03 AM |
Dumping styles definition | gouletp | Word | 3 | 09-06-2011 10:29 AM |