I have a worksheet in which in the first row (starting from D1) I will have Answer “YES” and Answer “NO”
If the answer is “YES”, the macro must convert all formulas to values in a specific range.
If D1 = “YES”, then convert to values range D2:D2000
If AA1 = “YES”, then convert to values range AA2:AA2000
If AC1 = “NO”, then do nothing
Hopefully it is easy to do..