how do you auto sort based on certain column

[juniperjacobs]

Hi,
i'm looking to auto-sort a worksheet based on column AY. i know i could use the sort button, but i'm not the one using the sheet, and it would be easier for the person using it to be able to click a macro that sorts by column AY with one click of a button. Macros are not my strong-suit, can someone provide the code?

thanks so much.

[davesexcel]

What's the Range?

[TMS]

Maybe:

Please Login or Register  to view this content.

Regards

[juniperjacobs]

it would be columns A2:AZ2 based on AY2.

[TMS]

Change this:

.SetRange Range("AY:AY")

to this:

.SetRange Range("A:AZ")


Regards