A Macro to insert lines and then text on multiple tabs

[rms]

Hi all,
Is there a way using a macro to insert lines and text into multilpe tabs of a workbook? Here's my problem, I have a workbook of about a hundred tabs. I need to insert 5 lines at the top of each spreadsheet and insert the same text in cell C2 and cell C3. I am basically inserting a title for each spreadsheet. Can anybody help me? Thanks in advance.

 

[Datsmart]

You can select all the Worksheet tabs you want to edit the same.
Then edit the active one, adding rows, etc. The changes will take place on all the tabs you have selected.

 

[rms]

wow Datsmart,
thanks for the quick response. I didn't know it was that easy. thank you for your help. I really appreciate it.