Thread: insert no of worksheets at a time
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default insert no of worksheets at a time
To insert multiple sheets at the same time, you can use code like

Sub InsertSheets()
ThisWorkbook.Worksheets.Add Count:=5
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"rajani" wrote in message
...
how i get more no of worksheets at a time please explain briefly

Reply With QuoteReply With Quote