View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ronbo Ronbo is offline
external usenet poster
 
Posts: 162
Default Return WB to original state

Does anyone know of a way to:

1. After perfroming a lot of calculations in a workbook (well over 100 and
to many to consider undo)

2. Keep/Save results (this only consists of 12 cells)

3. Get the WorkBook back to the original state.

4. Paste in the new results.

Also;

Can I "SaveAs" and keep the original WorkBook open and active?

Can I create a Copy of an open WorkBook?

As always, any help is appreciated.

Regards



Before I go to a lot of work trhrough a real roundabout method I am looking
for someone