Autofilter Sorting Macro

Hello - I recorded a Macro to autofilter a range of cells with data in it. I then tried to transcribe the recorded macro into my own code, but am having difficulty understanding why it does not work. It returns the following error: "Run-time error '424': Object required'. To give you an idea of what the spreadsheet looks like, I have a list of headers in row 1. The data is listed in columns A - Q and I'd like to sort by column L from largest to smallest value.

Please Login or Register  to view this content.

Thanks in advance!

According to another thread, you need to check if sheet is in AutoFilterMode? It seems to have done the trick! See "Andy Pope" answer:

http://www.excelforum.com/excel-prog...e-not-set.html


"Your code leaves the autofilter in place when either of the 2 routines runs.
This means next time a routine is run the Autofilter command actually removes the autofilter which is why the clearing of the sort fails.
You need to test for the autofilter being present are applying if not."

Please Login or Register  to view this content.