saving a copy without formulas

[Ravi Kumar]

I am trying to save a copy from a template which contains values in place of
formulas. I want user to enter inputs in to template sheet allow the user to
save copy with results of formula alone. The origional formula shall not be
copied to copy saved from my template. Please help.

Thanks

 

[Jacob Skaria]

Please check the replies for your previous post.

if you are looking to do that manually; use Ctrl+A to
select and copy. Target sheet Ctrl+A and Right click Paste special|Values.....

If programatically refer the post by Mike H

If this post helps click Yes

 

[Ravi Kumar]

Thank You Jacob Skaria,

But the reply did not give me the required advice. Probably, I could not
pose my question properly. What I need is, when I open a template a read
only workbook opens, On saving a copy of perhaps after filling in the blanks
it should save only value but not formulas to the copy. If I am clear with
my problem Please help out. Thank U.

 

[Simon Lloyd]

If you want code to change all formulae to static figures then drop thi
in your save code at the beginning (provided you want all sheets to b
processed the same

Dim Sh As Workshee
For Each Sh In Sheet
Sh.UsedRange = Sh.UsedRange.Valu
Next S

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com