Finding the last row dynamically
Solved/Closed
Related:
- Finding the last row dynamically
- Saints row 2 cheats - Guide
- How to delete a row in word - Guide
- Finding friends on ps4 blizzoid com - Guide
- Saints row pc download - Download - Action and adventure
- The following excel image has a vba program (see below). what will be the result after the program is executed? any cells not displayed are currently empty, and any cells with numbers are formatted numeric. sub afdo a=0 lastrow = cels(rows. count, 1). end(xdup). row for i =14 to lastrow step 2 a=a cellsii. 5) value next cells(lastrow 2, 1) value = "the sum - Guide
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
