I am using this code:

ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[9],refman,2,FALSE)"
Selection.Copy

I need to break up the table "refman" into 2 tables. Is it possible to have
the vlookup check both tables ( say refman1 and refman2) ?

Thank you in advance.