How to replace Excel formula with VBA code

23:57 18 Dec 2022

How do I write this formula in Excel VBA?

=IF(AY2=AX2,AW2,"")

I copied this formula in VBA, but the output shows '1004' error.

excel vba excel-formula