Thread: Peculiar Problem when Doing a Sheet.Copy
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] aidan.heritage@virgin.net is offline
external usenet poster
  
Posts: 244
Default Peculiar Problem when Doing a Sheet.Copy
POSSIBLY it's a memory issue, but IF all sheets are being copied and
renamed, why not change tack and save the workbook AS a different name
(thus creating another copy) and rename each sheet in this one?

Reply With QuoteReply With Quote