>Hi
>what is the use of the variable xlShiftDown ?
>
>
>oExcel.activesheet.ROWS("1:" + ALLTRIM(STR(m.lnLines + m.lnOffset))).INSERT(xlShiftDown)
>
>
>
>Derek
That's the Excel constant and I think it was taken from a macro recording. I believe we need to use it as is. Excel constants can be easily obtained.
If it's not broken, fix it until it is.
My Blog