finding the last row dynamically Solved/Closed

Question

Hi,
I am using VBA in Excel 2007.  I have a worksheet which has multiple columns.  Each column has different number of rows.  
I want to find the last row in each column.

Currently, I used the following code and I cannot get the last row location beyond column A.
Please help!
**********************************************************************
do while column_location <100
Set rnglast_test = Worksheets("test").Range("A1").Offset(column_location).SpecialCells (xlCellTypeLastCell)
last_row_text = rnglast_top_3.row
column_location = column_location + 1
loop

rizvisa1 · Answer

if you want to find last used row for each column then you can use this (example for column B)

lastrow = cells(rows.count, "B").end(xlup).row

or

lastrow = cells(rows.count, 2).end(xlup).row

J · Answer

Thank you very much for your help

Finding the last row dynamically

2 responses

Similar discussions

Subscribe To Our Newsletter!