I have a PO log workbook which has an "if" formula in Column(AB) which
enters todays date in the cell, if anything is filled in Column(R) same
row. This performms as expected. I also have a before save event which
converts the formula to a value, code below

columns("AB").value = columns("AB").value

The problem is, it wipes all my "if" formulas to values. What do I need
to change to affect only those rows where there is something entered in
Column(R) and preserve my "if" formulae. TIA

Greg