Sort descending not bound to worksheet.

Hi!

I recorded a macro to sort a range of cells descending.
However I want to use the macro in several worksheets, but how do I rewrite to get it to work?
Current code looks like this and "locks" the code to sheet 1:

Please Login or Register  to view this content.

I require the range AB36:AD54 to be sorted after the values in column AB. Key =AB36.
Any suggestions?
Tia.

Why is it always like, as soon as you post the question you find the answer.
My solution:

Please Login or Register  to view this content.