AutoFill doesn't work when used in Excel com object!
 

I want copy a set of formulas in excel range say B18:AF18 to B18:AF35.
I have tried code. as based on follwoing pseudo code.

RangePtr pRngDest = Range(B18:AF18);
RangePtr pRngEnd = Range(B18:AF35);
pRngDest-Autofill(pRngEnd, XFillDefault);


Above code increase only Rows but doesn't copies formulae in consecutive rows.