Thread: Using Activecell.Address when defining name
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hardy[_8_] Hardy[_8_] is offline
external usenet poster
  
Posts: 1
Default Using Activecell.Address when defining name
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