View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nickm687 nickm687 is offline
external usenet poster
 
Posts: 20
Default Copy of workbook woithout formulas.

Hi,

Does anyone know how to write a macro so that when run an exact copy
of the current workbook is created but only with the values not the
formulas.

The workbook contains mroe than one sheet and includes graphs.

Thanks in advance.

Regrds
Nick