View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Automate Insert Worksheet & Name

I interpreted the request to add("inserting") sheets, not rename existing ones.


Gord

On Fri, 25 Apr 2008 18:46:32 GMT, "BNT1 via OfficeKB.com" <u19326@uwe wrote:

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