Macro with 4 sorting criteria

I have been using a macro with 3 sorting criteria since 1998. When I edit and put in a fourth criteria, I get an error (rum-time "1004". Application-defined or object-defined error). But it doesn't tell me what or where the error is to be fixed. I hope someone from this group can tell me how to fix. Here is my macro:

' Team Macro
' Macro recorded 3/22/98 by Meredith Powell
'
'

Please Login or Register  to view this content.

Any help would be greatly appreciated.

Range.Sort method has a limit of 3 criteria. And that's why Microsoft (AFAIK with Excel 2007) introduced Sort object.

Your code rewritten with it would be:

Please Login or Register  to view this content.

Comment: You probably know whether your data has a header so it's better to use .Header = xlYes or xlNo

Hi Kaper,

Thank you for trying to help me with my macro. Please note, I am not a programmer. I had someone else build this a long time ago for me. I tried copying your coding but still have errors. Here is what I did:

Please Login or Register  to view this content.

Can you write the exact code so I can just cut /copy/paste?

The code above was the full code, you used only part of it.

@Mhattley
Administrative Note:

We would very much like to help you with your query, however your post does not comply with our guidelines

Please take a moment to review how to add code tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Guideline #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here.

I have added the code tags for you today. Please take a few minutes to re-read our guidelines and rules that you agreed to when you joined and comply in the future.

I suggest uploading a sample file depicting same setup as actual file and explain what 4 criteria you are wanting to sort...