Finding the last row dynamically
Solved/Closed
Related:
- Finding the last row dynamically
- Saints row 2 cheats - Guide
- How to delete row in word - Guide
- Vba last non empty row - Guide
- Macro to insert row in excel based on criteria ✓ - Excel Forum
- Excel create unique id for each row ✓ - Excel Forum
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 4, 2010 at 01:30 PM
May 4, 2010 at 01:30 PM
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
lastrow = cells(rows.count, "B").end(xlup).row
or
lastrow = cells(rows.count, 2).end(xlup).row