Sort Macro - Cleaning up code

Hi Folks,

I've searched around and have been unable to find a concise explanation on how to clean up a VBA Sort macro. I was hoping someone might be able to use my code as an example and pare it down, while listing the reasons for why they did so.


This is a two column sort on a dynamic range.
The Sub is called from a command button on a user form after user info has been saved.
This sheet won't be the active sheet when the data is sorted.

Please Login or Register  to view this content.

Much appreciated.

That looks fine. You can do some factoring:

Please Login or Register  to view this content.

Sure.

Please Login or Register  to view this content.