| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Include sheetname dynamically in named range?
I have a workbook with about 35 sheets in it and a chart that
repeats on each page with the current data. I would gladly convert it to a dynamically ranged chart (so I can just replicate it on each sheet without editing the data source), but the problem is getting the worksheet name into the range. Can someone point out how I might do that? Thanks for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamically Changing Named Ranges | Excel Worksheet Functions | |||
| Add a data series dynamically to a named range? | Charts and Charting in Excel | |||
| dynamically building references to named ranges | Excel Discussion (Misc queries) | |||
| Excel will not include all of my non-adj ranges in a named range?? | Excel Worksheet Functions | |||
| How to dynamically reference a dynamic named range | Excel Worksheet Functions | |||
Threaded Mode
