Copy worksheet to new workbook : Values & Formats

  • Thread starter Thread starter Franck
  • Start date Start date
F

Franck

Hi,
Is it possible to cpy an entire worksheet (Values & Formats) to a new
workbook without copying formulas ?

Sheets(X).Copy is building links to previous workbook.

Thks for help
 
After coping go to Edit->Links, and break links, and excel will replace
links with values.
If you do it from VBA, which seems so, try with PasteSpecial metod.
 
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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Continue Excel to New Uear 9
Copy a worksheet to a new workbook 6
Excel Move or Copy Stopped Working? 0
How to transfer a worksheet into a new workbook and keep the formulas intact 5
Copy and Link Issues 2010 1
Copying range of formulas to anotehr workbook 4
About references 1

Back
Top