Macro - Sort Range Error

Ari - Feb 16, 2012 at 02:02 PM
 Blocked Profile - Feb 17, 2012 at 12:23 AM

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 response

Blocked Profile
Feb 17, 2012 at 12:23 AM

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.)

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

We trust that you understand.