Finding the last used row in a specific column...
 

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

Finding the last used row in a specific column...
 

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

Finding the last used row in a specific column...
 

Try this for column A in Sheet1

Lr = Sheets("sheet1").Range("A" & Rows.Count).End(xlUp).Row


--
Regards Ron de Bruin
http://www.rondebruin.nl



"havocdragon" wrote in message ...
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