Hello,
I am trying to figure out the following code in order
to update columns
please help me
Thanks
Oleg
If Cells(j, 9).Value = "" Then Cells(j, 9).FormulaR1C1 = "=IF(RC7=""N/A"",""N/A"",VLOOKUP(RC2,Details!C[-7]:C,8,0))" Cells(j, 9).Locked = True Cells(j, 9).FormulaHidden = True End If