VBA Vlookup Range
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)"
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC1,[TT_TIME.XLS]SHEET1!myrange,8,FALSE)
It doesnot work
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center