sort till last row

Hi every body
I have a sheet which includ some data and I update it several time it means added some row to my database each time when update
my problem is here
when I wrote a macro to sort this database in the macro I don't know how I can issue this code
because I have range for example : A3:F30 in macro
but each time when I update the file this range is changed and added to it for example A3:F34
it means 4 row added to my base data
and macro calculated for old range and miss 4 new range which added

I am waiting for your help

Considering that row 2 has your headers and data starts from row 3, try this code

Please Login or Register  to view this content.

Try this

Please Login or Register  to view this content.