View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
 
Posts: n/a
Default In Excel how can I access the Name Box value (address) in a formu.

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.