View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
BNT1 via OfficeKB.com BNT1 via OfficeKB.com is offline
external usenet poster
 
Posts: 125
Default Automate Insert Worksheet & Name

Hi

Had this reply which worked for me

http://www.officekb.com/Uwe/Forum.as...heet-from-list


regards

Benjamin wrote:
I have a list of Tab Names. Is there any way to automate the process of
inserting a new worksheet and naming it from the list?

List
A
B
C
D
Etc.

To make Worksheets A, B, C, and D?

thanks


--
Message posted via http://www.officekb.com