I am writing a macro that will fill in vlookups, I thought what I had wrote would stop when the cell to the left(In Column E) was blank. But it fills down to the very last row.
'=VLOOKUP(E3,'SKU DETAIL'!B:D,3,FALSE)
Range("f3:f" & (Range("e" & Rows.Count).End(xlDown).Row)).FormulaR1C1 = _
"=VLOOKUP(RC[-1],'sku detail'!C[-4]:C[-2],3,FALSE)"
Can anyone tell me what I'm missing to get this to stop once a blank cell in column E appears?
'=VLOOKUP(E3,'SKU DETAIL'!B:D,3,FALSE)
Range("f3:f" & (Range("e" & Rows.Count).End(xlDown).Row)).FormulaR1C1 = _
"=VLOOKUP(RC[-1],'sku detail'!C[-4]:C[-2],3,FALSE)"
Can anyone tell me what I'm missing to get this to stop once a blank cell in column E appears?