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
|