Hi,
Is there a VBA method to check each cell in a sheet to see if it contains any type of formula,
and if so, convert it to a Value?
Thanks.
Hi,
Is there a VBA method to check each cell in a sheet to see if it contains any type of formula,
and if so, convert it to a Value?
Thanks.
Maybe:
Please Login or Register to view this content.
Thanks John (again).
This is linked to that earlier post, in that, before I save to a .xlsx format workbook, I need to preserve the user's data as fixed values.
In the original .xlsm book, these formulae are generated partly by code, and partly by worksheet formulae
placed into the cells.
Many are interdependent.
I'm thinking that I will have to be careful as to the sequence in which formulas are converted to fixed values ?
Regards.
Why not just convert the entire range to values instead of looping through each cell as the end result will be the same?
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks