something like

for i=cells(rows.count,"a").end(xlup).row to 2 step -2
rows(i).insert
next i

--
Don Guillett
SalesAid Software

"Greg" wrote in message
...
Is it possible to insert a row in every other line all at ounce in an
excel
document?
In otherwords I have an Excel document that I have to insert a new row at
every other line and would like a way to do it all in one shot instead of
manually right-clicking each line and inserting a row.

If possible how can this be done

Thanks in advance.
Greg