Sum of relative cell in a column

**Chetan Chauhan** · 07-30-2009, 07:46 AM

Hi

I have the code below which get the sum of the data in a column irrespective of the data range. But now the no. of topRow is not a constant one. Everyday I have to change the value of the vRowTop. Is there any way that macro counts the value for vRowTop itself?
The rows above the range sometimes contain Blank cell and somtimes data.

vRowTop = 5
vRowBottom = ActiveCell.Offset(-1, 0).Row
vDiff = vRowBottom - vRowTop + 1
Selection.FormulaR1C1 = "=SUM(R[" & -vDiff & "]C:R[-1]C)"

Thanks
Chetan

**DonkeyOte** · 07-30-2009, 08:40 AM

Is there any way by which you can always determine vRowTop ? Does the cell of interest always contain a value of some sort, is it the first row of data etc etc...

It might be an idea to post a sample file which illustrates exactly how you're using the above code.

**Chetan Chauhan** · 07-30-2009, 09:10 AM

Hi Donkeyote,

Please find the sheet attached. Previously the cell above the 5th cell were empty and the value starts from 5th row but now it has some data in the above cell and the range to be calculate starts from 5th,6th or from 11th even sometimes which is not fixed.

Hope this will help.

Thanks
Chetan

**DonkeyOte** · 07-30-2009, 09:19 AM

Sorry, I still don't follow... in order for you to automate something you really need for there to exist some underlying "logic"... ie if the start row is decided on a "whim" then it can't be automated...

Thus far you've not really provided any info which we could deem as logic to determine as to why you start at row 5 once, then sometimes row 6, or row 11 etc...