ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Replacing formulas with values programmatically (https://www.excelbanter.com/excel-programming/409672-replacing-formulas-values-programmatically.html)

Nils Magnus

Replacing formulas with values programmatically
 
Hello,

How do I programmatically replace formulas in a field with values? I
want to let users download an Excel sheet with the current values, but
without letting them see the formulas.


Regards,
Nils Magnus

Ron de Bruin

Replacing formulas with values programmatically
 
See this page Nils
http://www.rondebruin.nl/values.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Nils Magnus" wrote in message ...
Hello,

How do I programmatically replace formulas in a field with values? I
want to let users download an Excel sheet with the current values, but
without letting them see the formulas.


Regards,
Nils Magnus


Nils Magnus

Replacing formulas with values programmatically
 
Ron de Bruin wrote:
See this page Nils
http://www.rondebruin.nl/values.htm


Perfect! Thank you for the quick reply :-)


Regards,
Nils Magnus


All times are GMT +1. The time now is 12:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com