| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting a formula to its value
columms(1).value=columns(1).formula
-- Don Guillett SalesAid Software wrote in message ups.com... I am writing a program that updates a large excel workbook on a weekly basis. There are a couple of worksheets that I copy in the current weeks data and the remaining worksheets perform their calculations based on the current data. Is there a way to convert the cells containing formulas to their values, so that next week when I run the program the previous weeks data will remain? Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting formula into values | Excel Discussion (Misc queries) | |||
| Converting a Formula stored as String to real Formula | Excel Worksheet Functions | |||
| Converting a formula to its value | Excel Worksheet Functions | |||
| Formula not converting | Excel Worksheet Functions | |||
| Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
