I am trying to set a formula to recognise the location of the "cursor" such
as "B2". I only see this information in one place that is the "Name Box"
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?

"Daddy Buckets" wrote:

I am trying to set a formula to recognise the location of the "cursor" such
as "B2". I only see this information in one place that is the "Name Box"
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("A1").Value = ActiveCell.Address(False, False)
End Sub
'-----

HTH
--
AP

"Daddy Buckets" <Daddy a écrit dans le
message de news: ...
I am trying to set a formula to recognise the location of the "cursor" such
as "B2". I only see this information in one place that is the "Name Box"
located in the upper left hand corner of the Excel application.