Is it Possible

J

John

I was wondering if it was possible t0 have a formula in a specific cell that
will carry out a computation on the Row that is currently activated?

For example, if I want evaluated in T1 the sum of A:H in whatever Row was
currently active?

Thanks
 
P

Per Erik Midtrød

I think you must use VBA to accomplish this.
Consider the following:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim r As Long
r = Selection.Row
Range("T1").Formula = "=sum(A" & r & ":H" & r & ")"
End Sub

Right click your worksheet, choose view code and paste it.

Per Erik
 
Top