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 >>