Autofill a range in excel

[SkysLastChance]

I am trying to autofill a range. I am getting stuck and I don't understand what I am doing wrong. 

My goal is to auto fill some formulas that are next to a pivot table in columns A-C. 

_Excel_RangeWrite($oNewWorkBook,Default,"2000","D3")
_Excel_RangeWrite($oNewWorkBook,Default,"=(B3-D3)","E3")
_Excel_RangeWrite($oNewWorkBook,Default,"100","F3")
_Excel_RangeWrite($oNewWorkBook,Default,"=(C3-F3)","G3")

$oNewWorkbook.ActiveSheet.Range("D3:G3").Select

With $oNewWorkbook
    .Selection.AutoFill(.Range("D3:G77"),0)
EndWith

The data is not auto filling. 

Hoping someone can point me in the right direction. 

[water]

When writing formulas to a cell you have to set parameter $bValue (Parameter 5) to False.

[water]

This works just fine for me:

#include <Excel.au3>
Global $oExcel = _Excel_Open()
Global $oNewWorkbook = _Excel_BookNew($oExcel)
_Excel_RangeWrite($oNewWorkbook, Default, "2000", "D3")
_Excel_RangeWrite($oNewWorkbook, Default, "=(B3-D3)", "E3")
_Excel_RangeWrite($oNewWorkbook, Default, "100", "F3")
_Excel_RangeWrite($oNewWorkbook, Default, "=(C3-F3)", "G3")

$oRangeRow = $oNewWorkbook.ActiveSheet.Range("D3:G3")
$oRangeRow.AutoFill($oNewWorkbook.ActiveSheet.Range("D3:G77"), 0)

Seems $bValue is not needed. Excel detects formulas and processes them as needed.