how to use the active cell in an Excel formula

[Guest]

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).

 

[Guest]

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.

 

[Guest]

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