Sorting specific Rang of Cell in Multiple sheets of a Workbook having same Formate, Rows and Columns

[Qazi Sharifullah]

Good Morning,
I have 338 Sheets in a workbook and Having different data but the heading row is same in all sheets A8.
I want to Sort Data in All sheets from A9 to AR18 on the basis of Column AD (Heading AD8). I need Help about this As It spend Hours when I Sort individually each sheet.



Thanks
Regards: Qazi Sharifullah

 

[Qazi Sharifullah]

SCREEN SHOT OF THE EXCEL SHEET IS LINKED PLEASE CHECK IT.
https://1drv.ms/u/s!AonHeVVTfanFg3t0Okdeb13Y3EQC

 

[Qazi Sharifullah]

then you will probably find it is recalculating the formula after the sort as both codes sort ascending from ad9 (and yes i have tested them although the first code has an issue with the last cell in the range).

On a copy of of your workbook copy/paste as values column ad and test.

i try it but copy/paste as values but effects full sheet rows and also in descending order.

 

[MARK858]

It is definitely not in descending order, it is ascending and only from AD9 when I test. You are definitely looking at column AD?

Fluff's code will only sort from row 9 to 18, the other code will sort from row 9 past whatever is the last row.

 

[Fluff]

Your screen shot shows it sorted ascending!