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