MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copy method in a click event


Posted by Kevin on August 20, 2001 12:27 PM

I have a command button on a worksheet and when that button
is clicked I want the sheet to copy. I keep getting a
'Copy method of Worksheet Class failed.' The code I am using is
Sheets("Final Report").Copy. I do not get this
error when I have a command button on a form as a custom
dialog box using the same code. I always need this
command button on the worksheet. I do not want a range
copied, I need the entire sheet copied.
Does anyone have any ideas?


Posted by Russell Hauf on August 20, 2001 12:52 PM

Try:

Sheets("Final Report").Cells.Select
Selection.Copy

Hope this helps,

Russell