Solved: Sorting Issues.

[orcas]

Hello guys,

I'm having a little issue I'm hoping someone could help with.

The attached excel file contain different tables on different sheets. These tables are the portions colored in green.

I have written a code to go through each spreadsheet and sort the tables in ascending order on column K. The portions colored in blue are not to be sorted.

What i will like to be able to achieve if possible, is to make individual tables (i.e the green colored portions) really flexible so that when i insert additional rows, i can still sort them without having to modify portions of my code.

Any help received from you will be greatly appreciated.

[Aussiebear]

Rather than nominating a set range ("K3:K4000" I think it was), within the code, try naming the individual ranges and making them dynamic.