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.

Nick's picture

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)