VBA macto to filter by last workday

When you run the macro, and you get the error message, click on the debug button and advise us which line of code is highlighted.

I suspect that this is where the issue is: ActiveSheet.Range("A$2:X:X")

as this does not appear to be a valid range

Without seeing your workbook along with the code installed, it is difficult to determine what is happening. You may want to upload a sanitized copy of your workbook for analysis.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).

This is where you go wrong.

Please Login or Register  to view this content.

Also why calculate last filled row if you're not using it ?

Please Login or Register  to view this content.

Try this.

Please Login or Register  to view this content.