olegvolf
05-21-2020, 04:52 AM
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
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