Excel RangeWrite Formula help(Solved)

[xcaliber13]

Hello everyone

      I am having a hard time to figure out the correct syntax for an excel formula.  I use 

Global $iLastRow = $oWorkBook.ActiveSheet.UsedRange.Rows.Count
Global $iNextRow = $oWorkBook.ActiveSheet.UsedRange.Rows.Count + 2

as my variables.  

This works

_Excel_RangeWrite($oWorkbook, Default, "=SUM(D2:D136)", "D" & $iNextRow)

But I want to use $iLastRow in the formula 

_Excel_RangeWrite($oWorkbook, Default, "=SUM(D2:D"& $iLastRow)"", "D" & $iNextRow)

This is just one example of the many different ways I have tried to get this to work without getting a syntax error.  What am I doing wrong?  Thank you

[JLogan3o13]

In your second snippet, why the double "" after $iLastRow?

Edit: Nevermind, I see it now, I would try something like 

"=SUM(D2:D"& $iLastRow & ")"

 

Edited February 6, 2020 by JLogan3o13

[Subz]

Shouldn't it be:

_Excel_RangeWrite($oWorkbook, Default, "=SUM(D2:D"& $iLastRow & ")", "D" & $iNextRow)

 

[xcaliber13]

Thanks Guys  that did it.