For column A use...

lastrow = cells(rows.count, "A").end(xlUp).Row
--
HTH...

Jim Thomlinson


"havocdragon" wrote:

Hi all.

Currently I am using
Lastrow = Activesheet.usedrange.row - 1 + activesheet.usedrange.rows.count

I can't seem to figure out how to get this to work in a specified column