edit range name
The Add Name threw me off, thought it should be Edit Name.
But it works.
Thanx.
"FSt1" wrote:
hi
perhaps a small syntax problems....
Range("xfd100").End(xlToLeft).Select
ActiveWorkbook.Names.Add Name:="variance", RefersTo:=Selection
regards
FSt1
"MikeF" wrote:
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
|