View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Manos Manos is offline
external usenet poster
 
Posts: 50
Default Copy Paste a sheet to new workbook

Dear all

i do not have to many knoweldeges for vb.
what i am looking for is that: I have a workbook with many sheets where i
fill on specific sheet with to many formulas (Sheet 1).
There is any way to have a macro where to copy this sheet exactly as it is,
into a new workbook, but without the formulas? (copy paste values and
formats).

Thanks in advance
Manos