Macro - Run Time Error 9 (Subscript out of range)

[Joshdm0716]

Hello to everyone and in need of your HELP. 

Created this macro that basically formats a report that we downloaded from a source. I shared it to other users but when they tried running the macro they are getting a 'Run Time Error '9' Subscript out of range'.

I click Debug and it highlights the following line in my macro.

ActiveWorkbook.Worksheets("Previous_Day_Summary_and_Detail").AutoFilter.Sort. _SortFields.Clear

Any help is sincerely appreciated.

Please Login or Register  to view this content.

[ThirtyTwo]

gave you tried something as simple as

Please Login or Register  to view this content.

Or create a little macro to ensure that there aren't any filters or sorts already applied to the range, it's struggling with removing filters that don't exist. There's loads of options available to resolve this type of issue. Is it possible for you to create a stripped out version of the file you are working on ? Just keep the code, but remove any sensitive data from the worksheets

[dlow]

Yup, subscript outta range is your code looking for something that you told it was available, but isn't. Filter, Sheet, Range, Cell..... something.

I think Excel doesn't like how you are calling your worksheet.
Try this:

Please Login or Register  to view this content.

The on Error thing will skip the Error, but not fix the problem, if there is one.
I use it as a last result.
Just guessing.

Good Luck.

dirty

[AB33]

Run Time Error 9 (Subscript out of range)
usually means the object you are trying to access does not exist in the collection. It is highly likely the sheet does not exist in sheet collection, or there is a typo. Check if you have a sheet named "Previous_Day_Summary_and_Detail" in the work book you are working on.