Thread: Using Activecell.Address when defining name
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Using Activecell.Address when defining name

Use Address instead of Addresslocal

ActiveWorkbook.Names.Add Name:=sNameString, _
RefersTo:="=" & ActiveCell.Address

VBA/Excel should make the necessary adjustments.

or

ActiveCell.Name = sNameString

--
Regards,
Tom Ogilvy


"Hardy " wrote in message
...
Hi,

When using
ActiveWorkbook.Names.Add Name:=sNameString,
RefersTo:=ActiveCell.AddressLocal

To put the name stored in sNameString to the active cell, it does not
work because ActiveCell.Addreslocal returns "$B$2" rather than $B$2.
What is the easiest way around this?

Thanks


---
Message posted from http://www.ExcelForum.com/



Reply With QuoteReply With Quote