If the user is on range("20c") how can I no this.
Have tried with activecell example in VBA help but does no give me any
value

Thanks

VaiableX = activecell.value

"Susan Hayes" wrote:

If the user is on range("20c") how can I no this.
Have tried with activecell example in VBA help but does no give me any
value

Thanks

Hi Susan,

If the user is on range("20c")
I presume you mean Range("C20") .

how can I no this.

Sub Tester()
Dim rng As Range
Set rng = ActiveCell
MsgBox rng.Address(0, 0)
End Sub

---
Regards,
Norman



"Susan Hayes" wrote in message
...
If the user is on range("20c") how can I no this.
Have tried with activecell example in VBA help but does no give me any
value

Thanks

Activecell returns the object that is the active cell. This object has many
properties that you can interrogate.

For instance, ACtivecell.Value will give you the actual value in that cell.
Activecell.Text will give you the text in that cell (for instance, if you
have a value of 1 in a cell, but it is formatted as currency, this will give
the text value of $1.00 as seen on the worksheet)
Activecell.Address gives the address string of that cell, such as $A$1.

There are many others, take a look at 'Range Object' in VBA help (Activecell
is just a specific example of a range), and look at the properties
associated with it to find out about more.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Susan Hayes" wrote in message
...
If the user is on range("20c") how can I no this.
Have tried with activecell example in VBA help but does no give me any
value

Thanks