software

I am trying to set a formula to recognise the location of the quot;cursorquot; such
as quot;B2quot;. I only see this information in one place that is the quot;Name Boxquot;
located in the upper left hand corner of the Excel application.

Totally not clear what you want to achieve here! Are you trying to write a
formula, but do not want to type in the referenced cell addresses? Or are
you trying to write a macro, and want to know how to refer to a variable cell
address?

quot;Daddy Bucketsquot; wrote:

gt; I am trying to set a formula to recognise the location of the quot;cursorquot; such
gt; as quot;B2quot;. I only see this information in one place that is the quot;Name Boxquot;
gt; located in the upper left hand corner of the Excel application.

What you want is not quite clear.

Try pasting following code in worksheet's code:

'-----
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range(quot;A1quot;).Value = ActiveCell.Address(False, False)
End Sub
'-----

HTH
--
AP

quot;Daddy Bucketsquot; lt;Daddy gt; a écrit dans le
message de news: ...
gt;I am trying to set a formula to recognise the location of the quot;cursorquot; such
gt; as quot;B2quot;. I only see this information in one place that is the quot;Name Boxquot;
gt; located in the upper left hand corner of the Excel application.