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.