cell name - macro
 

Hello,

I wrote this macro to name a cell:

caddress = ActiveCell.Address
cursheetname = ActiveSheet.Name
ActiveSheet.Names.Add Name:="LAST", RefersToR1C1:="=cursheetname!caddress"

it does not work. anybody can help ?
thanks.

==
this also does not work:

ActiveSheet.Names.Add Name:="LAST",
RefersToR1C1:="=cursheetname!address(ReferenceStyl e:=xlR1C1)"

cell name - macro
 

try this simple line

activecell.name="Last"

--
Don Guillett
SalesAid Software

"alex" wrote in message
...
Hello,

I wrote this macro to name a cell:

caddress = ActiveCell.Address
cursheetname = ActiveSheet.Name
ActiveSheet.Names.Add Name:="LAST", RefersToR1C1:="=cursheetname!caddress"

it does not work. anybody can help ?
thanks.

==
this also does not work:

ActiveSheet.Names.Add Name:="LAST",
RefersToR1C1:="=cursheetname!address(ReferenceStyl e:=xlR1C1)"