Converting Macro that sorted table in 2007 to Excel 2003

I have a spreadsheet that has multiple tables in the same page that was created in excel 2007. I have users that still use 2003, so i need to basically build from scratch to accomodate.

Each table had a button assigned to it that sorted on a given row. the code looked like this:

Please Login or Register  to view this content.

I've come to realize Excel 2003 uses something called "Lists" rather than tables. So I used the macro recorder and sorted the "List" and came up with this code:

Please Login or Register  to view this content.

This works fine except as soon it only works on the original range c7:29. These tables/or lists can move up or down rows, and have rows inserted which renders this useless.

Any help is appreciated.

thanks!

Thanks for the ideas Holger! Both however yield a compile error. It didn't seem to recognize "CurrentRegion", and the second option the whole thing is highlighted red.

Attaching a sample copy if that helps.