Use:
range("A65536").End(xlUp).select to select the row
range("A65536").End(xlUp).row for the row number
range("A65536").End(xlUp).address for the cell address

Mangesh



"sisco98" wrote in message
...
Hi Everybody,

Does anyone know a way to select the last used cell in a column by using
macro? For example, there is a range filled with data from "A1" to "A30",
but
the closing cell is always changing (A32,A36...). I would like to find the
last data in column "A" by using VLOOKUP automatically.

Thank you in advance for your help,

sisco98