convert the functions and formulas to values

[Guest]

Hi
How to convert all the functions and formulas in the whole workbook to values without the method (copy, paste special as value)
Thanks

 

[Peo Sjoblom]

Why? Look at Value in the help for VBA

Range("A1").Value = Range("A1").Value

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

Hi,
How to convert all the functions and formulas in the whole workbook to

values without the method (copy, paste special as value).

 

[Stephen Bye]

If these options are missing from your Edit menu, you can use Tools >
Customize to put them back...

Hi,
How to convert all the functions and formulas in the whole workbook to

values without the method (copy, paste special as value).