Excel - determine the range dynamically

[Kevinski]

Hello

I have the following piece of code in a macro

Range("C2").Select
    ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-1],TLIST,2,FALSE)"
    Selection.AutoFill Destination:=Range("C2:C10")

This is fine for the 10 rows of data I used for testing but how do I repeat this function where I don't know how many rows of data I have?

In other words "perform this VLOOKUP in column 'C' for as many rows of data I have and then stop"

 

[PHV]

Have a look here: faq68-1331

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886