my mistake.

botRow = botRow -1


excuse me, the code is:

mLett 		= "h"
mCell 		= ""
botRow 		= oExcel.Application.ActiveSheet.UsedRange.rows.count
mCell 		= mLett + ALLTRIM(STR(botRow))
mSum 		= "=SUM(H1:H" + ALLTRIM(STR(botRow)) + ")"
oExcel.application.Range(mCell).Select	&& debit sum select
oexcel.application.ActiveCell.Formula = mSum  && debit total

>Hi, I am trying to do a sum of a column in Excel. The below place the formula in the right cell but the sum does not actually happen? The cell where the sum should appear remains blank, even though I can see the formula in fx bar.
>
>

>mLett 		= "h"
>mCell 		= ""
>botRow 		= o.Application.ActiveSheet.UsedRange.rows.count
>mCell 		= mLett + ALLTRIM(STR(botRow))
>mSum 		= "=SUM(H1:H" + ALLTRIM(STR(botRow)) + ")"
>oExcel.application.Range(mCell).Select	&& debit sum select
>oexcel.application.ActiveCell.Formula = mSum  && debit total
>

>
>Thank you.