(Solved) – Change a range to values if a criteria of another range is met?


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.

For example:

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..


Leave a Reply

Your email address will not be published. Required fields are marked *