Is it Possible
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 |
Is it Possible
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 |
All times are GMT +1. The time now is 02:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com