Hi
to get the lastrow filled in column A you may use something like
LastRow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).row

--
Regards
Frank Kabel
Frankfurt, Germany

"AaronJay" schrieb im Newsbeitrag
...
Hi,

I am trying to create a Macro to preform a Vlookup and carry the
results to the last record in the sheet.
Any ideas?

Thanks,
Aaron