Running Macro not responding

[RJ1969]

Hello

I am running a macro but its bot responding in Excel Window 10.
I know the macro is good. I tried the safe mode in excel but still not working.
When I run the macro it will say (running) but then later it will show (running)(not responding)...
What I need to do? thanks

[Marc L]

Hi,

nothin' as you « know the macro is good » …

Or just change your mind and use the debug step-by-step mode hitting F8 key in order to follow the progress during the execution …

[scottiex]

I suspect you would need to collect enough information for anyone to have a useful comment on it.

For example
1) I presume you mean the macro worked on a previous excel environment? what was that? are you sure that is the only variable?
2) did it run for a long time there as well?
3) can you show is the bit of the code that is slow? or all of it?
4) press escape when it is running and see if you can see where the code is having trouble? or F8 step through it and see if you can find where it has trouble?
5) what is it supposed to do?
6) upload an example sheet?