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

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

On Sun, 13 Nov 2005 12:59:09 -0000, "John" wrote:

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