Posted to microsoft.public.excel.programming

Hardy[_8_] Hardy[_8_] is offline

external usenet poster

Posts: 1

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
If activecell.column = variable then activecell,offset (0,1)	Battykoda via OfficeKB.com	Excel Discussion (Misc queries)	1	October 2nd 07 08:05 PM
Defining an Activecell	Ant	Excel Discussion (Misc queries)	6	October 3rd 05 05:32 PM
Activecell address	Patty2005[_4_]	Excel Programming	2	August 7th 04 03:58 AM
ActiveCell.Address	Todd Huttenstine	Excel Programming	3	July 27th 04 04:45 PM
LINKING Address cells from an EXCEL spreadsheet to fill MapQuest Address Info	Duane S. Meyer	Excel Programming	0	August 30th 03 12:16 AM

All times are GMT +1. The time now is 06:04 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us