Excel Row Insert Queston (Solved)

[xcaliber13]

Hello,

            I am trying to insert a row in Excel.  

$oWorkbook.ActiveSheet.Range($a&":"&$a).EntireRow.Insert

This inserts a row above the row.   I want to insert the row below the row.   How would I do that?    I have tried  $xlDown  that gets an undeclared global variable.  Tried $xlShiftDown no errors but still inserting above the row.   Thank you for any help.  

[xcaliber13]

Ok guys  I got it to  work.  I Just did this:

$oWorkbook.ActiveSheet.Range($a +1&":"&$a +1).EntireRow.Insert

 

[water]

Did you have a look at the Excel UDF provided with AutoIt? I recommend function _Excel_RangeInsert.