M
Max
Hi guys,
I'm trying to improve the sub below, so that:
a) it auto-detects the extent of the data range in col A
(A2:Ax, where x = last cell)
and inserts the vlookup formula correspondingly into col C
b) it will then auto-convert the returns in col C to values,
after calculation
Sub InsertFormulas()
With Sheets("Book In").Range("C2:C100")
' Adjust the range in col C to suit
' the max likely number of data rows in col A
.FormulaR1C1 = _
"=IF(RC1="""","""",VLOOKUP(RC1,PartNumbers!R2C1:R1000C2,2,FALSE))"
End With
End Sub
Thanks for insights
I'm trying to improve the sub below, so that:
a) it auto-detects the extent of the data range in col A
(A2:Ax, where x = last cell)
and inserts the vlookup formula correspondingly into col C
b) it will then auto-convert the returns in col C to values,
after calculation
Sub InsertFormulas()
With Sheets("Book In").Range("C2:C100")
' Adjust the range in col C to suit
' the max likely number of data rows in col A
.FormulaR1C1 = _
"=IF(RC1="""","""",VLOOKUP(RC1,PartNumbers!R2C1:R1000C2,2,FALSE))"
End With
End Sub
Thanks for insights