View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Miguel Zapico
Posts: n/a
Default how to use the active cell in an Excel formula

You can use VBA for that, with the Workbook event SelectionChange, for example:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
ActiveSheet.Range("B2").Formula = "=" & Target.Address
End Sub
This will change the formula in B2 to show the value of the selected cell,
you can make it more complex and add error checking (to avoid circular
references, for example)

Hope this helps,

"EPMMGR06" wrote:

Is it possible to write Excel formulas and reference the active cell as part
of the formula.
As you scroll you data, a cell at the top of the spreadsheet would show the
results of a formula that was being calculated based on where the cursor was
(active cell).