Sort 1004 error

I used this exact code on one of my spreadsheets and it worked great, I had a previous thread about this.

Please Login or Register  to view this content.

Now, I've moved this code to another spreadsheet, changed the ranges, and I'm getting a runtime error 1004, sort reference is not valid, make sure its within the data you want to sort etc...

Please Login or Register  to view this content.

L10 falls inside the range, and L10 has data, as does the rest of the column below it.

Originally Posted by davegugg

Your second line seems to have a sytax error at the end; there is a , _ instead of a open parenthese.

Yeah, just something in the way it pasted.

The yellow highlighted area in the VBA editor says this is the problem :

Please Login or Register  to view this content.