Copy sheet to another specified file

  • Thread starter Thread starter Rob
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Range(sheet2) = Range(sheet1) 11
Automated Copy Paste 1
Unhide sheet, copy and rename new sheets from list, rehide sheet 8
Value from one sheet paste under same value on other sheet. 7
macro to copy columns from one sheet to another sheet 4
VBA Code for Pasting Sheets 2
Re: Reference must be to a macro sheet? 0
Excel Macro to copy a row to another sheet based on date 0

Back
Top