Thread: Copy sheet problem
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Copy sheet problem
My second suggestion would solve that problem.

--
Regards,
Tom Ogilvy


"SiriS " wrote in message
...
Sorry, I did not explain correctly. My problem is I have buttons, graphs
and drawingobjects in my sheet that I would like to copy, not just the
cells; I do want to copy everything in the sheet.

Do I have to do like this:

Sheets.Add Befo=Sheets(1) 'Copy Cells
Sheets("Mysheet").Cells.Copy
Sheets(ActiveSheet.Name).Paste
Sheets("Mysheet").DrawingObjects.Copy 'Copy drawingobjects
Sheets(ActiveSheet.Name).Paste
...
'Copy graphs etc.

and so on, for every type of object in the sheet?


Regards
SiriS


---
Message posted from http://www.ExcelForum.com/



Reply With QuoteReply With Quote