MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copy/Move/Insert row/columns into multiple worksheets


Posted by Alex on January 16, 2002 8:17 PM

I have difficalties to find an answer on how to insert or copy or move row/columns simultaneously to multiple worksheets. Please advise.

Thanks,
Alex


Posted by Jacob on January 16, 2002 9:08 PM

Hi

Lets say you want to work with 3 sheets name "Sheet1"-"Sheet3" for example then

Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select

Would select all the sheets you could then do simultaneous changes to them all.

HTH

Jacob