Thread: Insert Rows
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Vinit[_2_] Vinit[_2_] is offline
external usenet poster
  
Posts: 18
Default Insert Rows
Hi Soniya,

Group the worksheet using following Macro:
Sheets(Array("Sheet5", "Sheet7", "Sheet8")).Select

Now every action performed on any group sheet will replicate to others

Regards,
Vinit

Reply With QuoteReply With Quote