View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default can we copy the sheetnames too?

Hi
no code :-)

--
Regards
Frank Kabel
Frankfurt, Germany


Martyn wrote:
Hi,
The below code copies the content of our workbook sheets seperately
as new workbooks, but saves the sheets with default "Sheet1",
"Sheet2" name format. Can we also copy the used sheet names while
copying?
TIA