View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cindy Wang Cindy Wang is offline
external usenet poster
 
Posts: 14
Default is there a way to control the sheet name you add

is there a way to control the sheet name you add? It could be called
sheet 1, sheet 2 or sheet3, etc. Is there a way to keep it same when
you add a new one? Or when you create a pivot, is there a way you
can always create from sheet1 when using a new sheet? I try to create
a macro, but could not control the sheet name and vloop would not be
able to find the sheet. Thanks,