I have a workbook with multiple tabs with a macro created by a consultant a few years ago. It has worked well up to now but since we converted to Excel 2010, the worksheet returns an error message unless all the tabs are unprotected. The message is “Run time error 1004. Sort method of Range class failed”. The line that is highlighted when I debug is the line below beginning rngDestination. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o> </o>
Next<o></o>
<o></o>
' Sort the destination named range<o></o>
rngDestination.Sort rngDestination, xlAscending<o></o>
<o> </o>
Does anyone know how to fix this? <o></o>
fficeffice" /><o></o><o
> </o>Next<o
></o><o
></o>' Sort the destination named range<o
></o>rngDestination.Sort rngDestination, xlAscending<o
></o><o
> </o>Does anyone know how to fix this? <o
></o>
