| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I change the reference to a named range via VBA?
Thanks to Chip and Dave.
This helps my understanding of referencing named ranges in VBA. "Dave Peterson" wrote in message ... You can just reassign the Name to a different range: worksheets("sheet99").range("z9").name = "Home" Bassman62 wrote: I have a range named "Home" that refers to: =Sheet1!$A$1. What Macro code would I use to change the reference? Thanks for any advice. -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reference first cell in a named range | Excel Worksheet Functions | |||
| Named range in chart - any way to change the workbook reference with VBA | Excel Programming | |||
| automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
| named range, offset self-reference | Excel Discussion (Misc queries) | |||
| Reference a named range | Excel Programming | |||
Threaded Mode
