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

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

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

I find this syntax easier:

Range("xfd100").End(xlToLeft).name = "variance"

If you wanted to use a worksheet level name:

With activesheet
.Range("xfd100").End(xlToLeft).name = "'" & .name & "'!variance"
end with

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

--

Dave Peterson