Run-time 91 error

I'm not entirely sure. I've just (for lack of a better word) 'inherited' this work tool from my predecessor who has since left the company. What I know is that there are a bunch of sheets, one for each warehouse we use and that these macros are supposed to sort the data and render printable versions. I don't know if that helps...

Attachment 730611

This image is a Table, where there are headers and arrows next to them. Like in the top left cell you see "Day of Week" then an arrow box next to it. If you don't see Headers with arrow boxes then it's NOT a table.

Here is a print screen of the sheet in question, if that helps

Attachment 730612

According to your description, its a table

There's bad code there. the line is actually stopping on:

Selection.AutoFilter

Need more time.

No problem, take the time you need. And thank you for your help, its much appreciated!

Quick fix is to Comment out 4 lines of code that seem broken / not applicable that causes it to stop
How to comment something to be ignored in code, just add a ' before text:
'This is a comment
This is not a comment

The 4 lines to comment out are:
'Selection.AutoFilter
and the 3 lines that say:
'.Apply

I tried it, but I got the same error code. Here is a screenshot in case I did it wrong:

Attachment 730621

The image isn't working so I can't see. I'm thinking that you have a different version of excel / office than I do.

If you want to sort manually, you can. (You might already know how to do it) Click the arrow box next to a header and it gives you options to sort.

I'm sorry I couldn't help much. Anyone else wanna try helping?

Thanks anyway, I really appreciate the effort you put in!

Try replacing this line

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

Perhaps there is no autofilter when it reaches that line.
Maybe actively remove AutoFilter before applying, then there's also no need to clear the sort. It'll also ensure that the filter is reapplied to the correct row.

Please Login or Register  to view this content.