Thread: Copy sheet problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SiriS SiriS is offline
external usenet poster
  
Posts: 1
Default Copy sheet problem
Hello,
I've got the run-time error "Copy method of worksheet class failed"
and is trying to use the MSDN workaround for this problem(se
http://support.microsoft.com/default...4&Product=xlw).

But in the MSDN workaround they only copy cells, I want to cop
everything in the sheet, format also.

Sheets.Add Befo=Sheets(1)
Sheets("Mysheet").Cells.Copy
Sheets(ActiveSheet.Name).Paste

How to copy everything in the sheet?

Thank you.

Siri

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

Reply With QuoteReply With Quote