Export multiple sheets to new workbook

[Bossie94]

Hi everyone,

I'm having trouble with my VBA code.
I have about 15 sheets in my workbook, but I want to export 5 sheets to a new workbook with the click of a button and save it in the same directory as the existing workbook.
The button part is easy. I looked up something for the exporting, but it isn't working properly.
Can someone gives me some tips?
This is what I got so far, I didn't use the actual names of the sheets.

Please Login or Register  to view this content.

I'm looking forward to your awnsers!

- Daan

[xladept]

Hi Bossie,

Try this:

Please Login or Register  to view this content.

[Bossie94]

Hi xladept,

It works!
Just one last question. In the existing workbook there are cells with formulas. When the sheets are copied, the formulas are visible in the formula bar. Is it possible that the cells in the copied sheets only show plain text instead of the formulas?

- Daan

[xladept]

Hi Bossie,

To paste only values:

Please Login or Register  to view this content.

[Bossie94]

It works!
Thanks for your help!

- Daan

[xladept]

You're welcome and thanks for the rep!