Copy sheet to another specified file
 

Hi,

I have the need to, due to memory when running an
automating macro have the information from a sheet in its
entirety copied (paste special, all equivelant) using a
button to do so. Can you tell me how I would code this
please. The sheet name is just sheet1.

Many Thanks.

Rob

Copy sheet to another specified file
 

With worksheets("Sheet1")
.cells.copy
.cells.PasteSpecial xlValues
End with

with replace all formulas in sheet1 with their displayed values.

If that isn't what you want, post back with a clear explanation of what you
are trying to do.

--
Regards,
Tom Ogilvy

"Rob" wrote in message
...
Hi,

I have the need to, due to memory when running an
automating macro have the information from a sheet in its
entirety copied (paste special, all equivelant) using a
button to do so. Can you tell me how I would code this
please. The sheet name is just sheet1.

Many Thanks.

Rob