Sort any worksheet

[bassinator]

Good morning all,

I've read some of the forums posts for sorts, it helps for the start of the code but gives me an error at the end. At the very end, it gives me Error, Object Variable or With block variable not set?

This will need to be done for any named sheets in different workbooks received.

Please Login or Register  to view this content.

[Bernie Deitrick]

Much better would be to simply record macros, one for each step (perhaps even in separate posts, with specific needs explained), and then post them here. With an example table, if possible.

A few general - why does your data seem to start in column B? Is column A empty, or is it filled? Your headers appear to be in row 4, so deleting from row 5 down ("'REMOVE DATA FOR TEAM") will cause the data and headers to be mismatched. Is your data always in B to AB, or can it extend beyond? Can you have more than 5000 rows of data? Will the "any worksheet" be constructed the same?