Macro to sort chart in the middle of a sheet.

[Tubtech]

I'm looking for a way to sort a chart down the worksheet page below other information using a macro. What I have is a chart that resides in cells W35:AB44. There are values in all cells within this chart. Is there any way to sort the 10 rows W35 to W44 by the value in AB35 in ascending order. I have included a workbook that shows the results I need, Any help will be welcomed, thanks!

[protonLeah]

Try:

Please Login or Register  to view this content.

[Tubtech]

Sorry i didn't get back sooner, i had a death in the family, I will look into this code. Thank you for your time!