munoeca, you don't need a macro, group the sheets, right click and select
all sheets, insert your row, it will be inserted in all sheets, don't forget
to ungroup the sheets when you are done.
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"nunoeca" wrote in
message ...

Can someone help?

I have a workbook with several sheets, where the first three columns of
each sheet are the same, and are supposed to have exactly the same
contents.

I have linked all the cells to the ones on the first sheet, but I need
to be able to insert a row somewhere in the first sheet, and that that
row is automatically inserted in all the ohter sheets in the workbook.

Is this possible? Does anyone know of a VBA script or a macro to do
this? I tried doing it with a macro, but it does not do it
automatically and also only inserts a specific row as saved in the
macro.

Thanks,

Nuno Eça




--
nunoeca
------------------------------------------------------------------------
nunoeca's Profile:
http://www.excelforum.com/member.php...o&userid=26200
View this thread: http://www.excelforum.com/showthread...hreadid=395063