Macro - Sort Range Error Closed

Question

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!! :)

Configuration: Windows XP / Internet Explorer 7.0

pcsces · Answer

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/apps-sites/internet-archeology/ccm/10131-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

Macro - Sort Range Error

1 response

Similar discussions

Subscribe To Our Newsletter!