convert the functions and formulas to values

  • Thread starter Mireille Abi Nader
  • Start date
M

Mireille Abi Nader

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

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


Mireille Abi Nader said:
Hi,
How to convert all the functions and formulas in the whole workbook to
Click to expand...
values without the method (copy, paste special as value).
 
S

Stephen Bye

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

Mireille Abi Nader said:
Hi,
How to convert all the functions and formulas in the whole workbook to
Click to expand...
values without the method (copy, paste special as value).
 
Top