Hi Bob,

Thank you for your help,

regards
--
sisco98


"Bob Phillips" wrote:


LastCell = Cells(Rows.Count,"A").End(xlUp)

--
HTH

Bob Phillips

"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