Hi Naomi,

The following statements work, but Excel inserted the lines at the top of the spreadsheet. Did I get the syntax correct?

Is the Rows command documented anywhere?

Thanks again, Chaim



lnLines = 10
lnOffset = 8
loWorkSheet.rows("1:" + alltrim(str(m.lnLines + m.lnOffset))).insert(-4121) && xlShiftDown