View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Art Art is offline
external usenet poster
 
Posts: 587
Default Save a sheet of a workbook to a sheet in a new workbook

Danny,

This isn't a VBA solution, but when I have to do that I do the following:

I do a sheet copy -- the whole sheet. Then on the copy of the sheet I
highlight everything, copy and paste values. This won't do formulas for you.


"Danny Verswyvel" wrote:

Does anybody know a methode how I can save a sheet with links to an other
sheet without these links?

any help?