Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
edit range name
Should be simple, but just can't nail the syntax.
There is an existing Range Name "Variance". Merely want whatever cell this line lands on --- Range("xfd100").End(xlToLeft).Select --- to become the new address of range name "Variance". Here's one of a few dozen I've tried that don't work: Range("xfd100").End(xlToLeft).Select ActiveWorkbook.Names("Variance").RefersToRange.Sel ection Thanx in advance for your assistance. - Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Edit formula over a range | Excel Worksheet Functions | |||
allow users to edit range | Excel Discussion (Misc queries) | |||
Macro to edit Range Name | Excel Programming | |||
How do I edit a selected range then copy the range into an new sheet??? | Excel Programming | |||
How to edit a named range | Excel Discussion (Misc queries) |