Is it Possible

  • Thread starter Thread starter John
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top