Macro - Sort Range Error [Closed]

Report
-
 Blocked Profile -
Hello,

I've created a Macro within Excel that is supposed to Delete, Formulate and Sort data.. I've managed to get the Macro to the point where it does all of the above except "Sort" various ranges of specified columns. I keep getting a "subscript error 9 out of range"

along with the following highlighted item when I select Debug:

ActiveWorkbook.Worksheets("Data Summary Report").Sort.SortFields.Clear

Why is it having such difficulty sorting the specified columns?

HELP!! :)

1 reply


Greetings,

Please, bare in mind that Kioskea is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.

Therefore, it is specifically requested from Kioskea forum users correspond showing mutual respect. Therefore, when requesting assistance, the use of polite expressions,as for elsewhere in similar circumstances, is appreciated. (please, thank you, appreciate, grateful, etc.)

https://ccm.net/contents/948-terms-of-use-for-ccm-respect-for-others#politesse

Please, copy, modify and repost your message respecting the politeness charter.

We trust that you understand.

Moderator

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!