Re: identify the name of the activecell not its address

From: Otto Moehrbach (ottomocobia97_at_bellsouth.net)
Date: 09/26/04

Next message: Tom Ogilvy: "Re: UBound not in Intellisense. References problem?"
Previous message: Tom Ogilvy: "Re: identify the name of the activecell not its address"
In reply to: RogerTheDodgerTheDirtyOldSod: "identify the name of the activecell not its address"
Messages sorted by: [ date ] [ thread ]

Date: Sun, 26 Sep 2004 16:53:40 -0400

Dim MyVariable as String
MyVariable = ActiveCell.Name.Name
HTH Otto
"RogerTheDodgerTheDirtyOldSod"
<RogerTheDodgerTheDirtyOldSod@discussions.microsoft.com> wrote in message
news:E35B3FAB-95F1-4654-8403-8818F375B0F0@microsoft.com...
>i need to assign the range name of the acivecell to a variable - How!!

Next message: Tom Ogilvy: "Re: UBound not in Intellisense. References problem?"
Previous message: Tom Ogilvy: "Re: identify the name of the activecell not its address"
In reply to: RogerTheDodgerTheDirtyOldSod: "identify the name of the activecell not its address"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: Error 91
... I am using a piece of vba code to 'Find' a cell containing a string. ... dialog that Excel displays, when the data is not found, when doing the Find ... > When you lose your mind, ... HTH Otto ...
(microsoft.public.excel.programming)
Re: Redefine UsedRange property of Worksheet Object
... For each Cell in Range ... HTH Otto ... via string variable called WorkingRange which has a new range address i ...
(microsoft.public.excel.programming)