View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GeneWan GeneWan is offline
external usenet poster
 
Posts: 21
Default new sheet with same name as previous.

if I execute a macro and it opens a sheet, how can I name the sheet to be of
the same name but this time with the following:

ex. first execute, filename is "My sheet"
second execute, filename becomes "My sheet (2)"