how to use the active cell in an Excel formula

E

EPMMGR06

Is it possible to write Excel formulas and reference the active cell as part
of the formula.
Use:
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).
 
M

Miguel Zapico

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,
Miguel.
 
C

CLR

With Change-event code.........this will multiply the value in Cell B1 times
the value in the Active-cell

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Range("a1").Value = Range("b1").Value * Target.Value
End Sub

Vaya con Dios,
Chuck, CABGx3
 
Top