Rnage.Sort Crash

[sleepydog]

Hello,

I have a macro (Excel 2007) that sorts the rows of a sheet using the range.sort method.
It works just fine.
My problem is that after the routine has completed, if the user decides he would like to perform an additional sort (with the Excel command, not though code.)
Excel will them immediately crash.

Once the file is opened again every thing is fine.

I am not really sure what to do about this and I have not had much luck finding people who have encountered similar situations on the web.

Anything that could point me in the proper direction would be appreciated.

Perhaps ther are suggestions on the proper way to close out of macro that can help avoid such errors.

Thanks in advance
Dave <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->

<!-- controls -->

 

[hiker95]

sleepydog,

Welcome to the MrExcel forum.

Can we see your macro code?

If posting VBA code, please use Code Tags, see below in my Signature block: If posting VBA code, please use Code Tags - like this