Using sort descending in VBA

I have some sheets which I would like to loop through and use sort descending on column S, would somebody help me out with the code to do so? I actually have the looping code already, I just need the sort descending bit.

Try recording a macro?

I used the macro recorder and inserted the recorded code into the macro I'm using. I'm getting an error on the .sort section of the code stating "method or data member" not found. I'm not sure of the syntax to point to the current worksheet either. Thanks for your patience with me on this. Edit: I removed the (s) from the worksheet object and the code runs but it isn't sorting the data.

Please Login or Register  to view this content.

Untested (I edited this in 2003). Your references were not qualified to the worksheet. The most important line in the code is the very first one.

Please Login or Register  to view this content.

Konnichi wa Eonizuka san,

Akemashite omedetō gozaimasu!

I can't edit Excel 2007 files, only read them. So, the modifications to your macro are untested, but it should work. Here is the modified macro.

Please Login or Register  to view this content.