Copy sheet to another specified file

R

Rob

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
 
T

Tom Ogilvy

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.
 
Top