how can one obtain the current selected cell value

[Susan Hayes]

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

 

[Guest]

VaiableX = activecell.value

 

[Norman Jones]

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

 

[Bob Phillips]

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)