How can I get/determine the last row that contains data for a specific column.
I have a sheet that I need to sort based on column "D" starting at row 14 (the first 13 rows need to remain as are) to the last row that has data in column "D" (so that all rows below that remain unsorted.
I can not do a count as every other row is blank. so for eaample:
if working with rows 14 - 20 (normally have much more), then I want my VBA to sort rows 14 - 20 on Column D so that the blank rows are moved to the bottom
Before Sorting:
row / info in column d
14 / 1234567
15 / "Blank"
16 / 9876543
17 / "Blank"
18 / 0192837
19 / "Blank"
20 / 5463728
Afrter Sorting
row / info in column d
14 / 0192837
15 / 1234567
16 / 5463728
17 / 9876543
18 / "blank"
19 / "blank"
20 / "blank"