Posted to microsoft.public.excel.programming

JP[_4_]

external usenet poster

Posts: 897

How to retreive the name of a named cell in an excel macro

If I name cell E2 "MyCell", the following code returns the name:

Range("E2").Name.name

This only works if it is a single cell named range.

--JP

On Aug 13, 12:35*pm, Xavier wrote:
I have no problem in addressing cells with name, adding names to the list but
have not yet found the way to retreive the name of the active cells. If any
one has a clue, this would be very appriciated.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Retreive part of the value from each cell - Macor and/or forumula	[email protected]	Excel Discussion (Misc queries)	5	October 28th 08 05:32 PM
Macro affecting hyperion retreive	Jim May	Excel Programming	0	April 5th 06 01:06 PM
VBA Excel Macro to delete contents in named cell	reaa	Excel Discussion (Misc queries)	1	January 3rd 06 08:16 PM
Macro Using Named Cell	Mark Bigelow	Excel Programming	0	July 8th 03 07:40 PM
Macro Using Named Cell	Dan E[_2_]	Excel Programming	0	July 8th 03 07:29 PM

All times are GMT +1. The time now is 07:58 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us