Hi,
This week ,I find a job as a Vb programmer. I have never used VB. I met a question about " VBA Range."

How can I replace " R1C1:R200C8" with Range, and Range need variant .
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC1,[TT_TIME.XLS]SHEET1!R1C1:R200C8,8,FALSE)"

my code:

set myrange=range(cells(1,1),cells(rowcount,8))

ActiveCell.FormulaR1C1 = "=VLOOKUP(RC1,[TT_TIME.XLS]SHEET1!myrange,8,FALSE)

It doesnot work