You can start with this code example
http://www.rondebruin.nl/copy4.htm
Post back if you need more help

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"LPS" wrote in message ...
Using Excel 2000, I have 8 workbooks, one sheet each, which all need the same
row added to the same place in each workbook, but it could be a different
location each time the rows are added (make sense?). For example, today I
may need to add a new row 5 to all 8 workbooks, but tomorrow I may ned to add
a new row 20 to all 8 workbooks. Is there a way to do this quickly, without
having to open each one and manually add the row in?

Any help is appreciated.
--
LPS

--
LPS