Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add another value to a named range
Hi,
I have a named range which refers to the contents of a pivot table. The range works fine and is used in a drop-down lookup (based on data validation). Essentially, a user picks a value from the list and this runs a macro. Thing is, I have been asked to extend the functionality of my spreadsheet and need to add a "catchall" to the front of the named range. What I need to do is have "(All)" added to the front of the named range. I cannot add it into my pivot table without changing the source data (which comes from an external database, automatically linked) I cannot add it manually to the data since this spreadsheet is meant to be automated once completed. Anyone any idea how I can add this value to the front of my named range? Rich |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Join non-contiguous ranges into one range via named range? | Excel Discussion (Misc queries) | |||
Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) |