How to go last row in a data
I have reports in which no. of rows has been changed. I have create a macro to sorting the report. Its work fine with 144 rows. But whenever there are more rows in report macro still shows first 144 rows. How can I program my macro to work accurately?
The problem is that I did not find the way to handle to go last row where data finished after sorting the data? How to I go to last row where a string "......" came? Plz help.
to find the last populated
to find the last populated cell in a column in VBA
ColumnToLookIn = 1 ' col A
set LastCell = cells(rows.count,ColumnToLookIn).end(xlup)
to find the next free cell in a column in VBA
set NextFreeCell = cells(rows.count,ColumnToLookIn).end(xlup).offset(1)