copy sheets to another workbook withou formulas using VBA

  • Thread starter Thread starter Henk van Walbeek
  • Start date Start date
H

Henk van Walbeek

I want to make a "hard copy" of 3 named sheets in my workbook to a new
workbook.
The new workbook should contain only "values" no formulas.
If possible the user should give the new sheet a name.

Regards
 
I do understand that,

but I want to do it with a Macro which copies the sheets first (including
lay-out etc) and the make values of it.

Henk
 
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

Copying range of formulas to anotehr workbook 4
Excel Move or Copy Stopped Working? 0
Copy a sheet contained formulas from one workbook to another and remove file links 3
Newbie for starters with excel, I am needing to transfer info fromsheet2 to the universe sheet. 1
COPY NAMED FORMULA 2
Macro to copy portion of each sheet and paste into the first sheet asa picture 1
Copy a worksheet to a new workbook 6
Macro executing (copy data) from at sett of sheets in the workbook 3

Back
Top