Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I change the reference to a named range via VBA?
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. |
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 |