>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
What row do you want to start? Replace "1:" with your number, that's what I meant. Rows and Columns are Excel objects, which you can manipulate...
I need to run now and would not be using UT for two days. Good luck!
If it's not broken, fix it until it is.
My Blog