Excel crashes after I run a macro and then try to save the file

[dreddster]

Hey guys,

I combined two macros I found into one. First is to copy rows, second is to custom sort on the first column. Macro runs fine, but when I try to save the file, Excel crashes. Any idea why the macro is causing this crash? Here is the macro:

Please Login or Register  to view this content.

Any help would be greatly appreciated

[patel45]

In your code there is a for loop without next, attach please a sample file for testing

[dreddster]

Thank you, Patel.

I have attached the file.test.xlsm

[patel45]

Your code causes crash also to me, but I don't understand why

[Philb1]

Hi Dredster
This solves the crashing problem + it copies & pastes to sheet 2. Not sure what the sort is supposed to do, but nothing happens

Please Login or Register  to view this content.

[dreddster]

Hey Philb1, I have been fighting with this macro for over a week. Your solution is perfect!

Thank you so much!

[Philb1]

You're welcome