ActiveCell.FormulaR1C1 = "CMH"
ActiveCell.Offset(0, 1).Select
ActiveCell.FormulaR1C1 = "No"
rvu = ActiveCell.Offset(0, 1).Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(" & _
rvu & ",'RVU Lookup'!A3:B7213,2,FALSE)"

--
Regards,
Tom Ogilvy



wrote in message
oups.com...
Hi

I have a macro that fills in some data, and makes the last cell in the
row the active cell. I want to use the vlookup function to get a
calculated value for the last cell of that row. I don't seem to be able
to correctly reference the lookup table (in another worksheet in the
same workbook, and labelled as RVU Lookup)

ActiveCell.FormulaR1C1 = "CMH"
ActiveCell.Offset(0, 1).Select
ActiveCell.FormulaR1C1 = "No"
rvu = ActiveCell.Offset(0, 1).Select
ActiveCell.FormulaR1C1 = VLOOKUP(rvu,'RVU Lookup'!A3:B7213,2,FALSE)

doesn't work

Thanks in advance

CLS