Sort Data When a Header Is Clicked

[Rasm]

Perfect - exactly what the Doctor ordered - Thanks

Also use FaceId 3157 & 3158 - symbols for sorting

I uploaded the final XLSM files under tips-Tricks and downloads - this is a very usefull tool - Excel Fox & Admin - thanks for your help.

[fioramonti]

Hello Folks,
Maybe I am just having first time hickups to the site but where is data passed for the sort?

Or I am missing a point on this macro?

[Rasm]

Fioramonti

This routine sorts the entire sheet from the headerrow down -- are you looking to only sort a single column of data or a range of cells?

Rasm

[fioramonti]

Hello frasm,

Yes, I would be sorting a range of rows, single column.

Thanks

fioramonti