| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding Number of cells in a column of other sheet having a specific word in them | New Users to Excel | |||
| i need help with finding a specific formula | Excel Discussion (Misc queries) | |||
| finding specific values in a within a file | New Users to Excel | |||
| Finding specific word in column | Excel Worksheet Functions | |||
| Finding specific column values in a variable row | Excel Programming | |||
Linear Mode
