VBA hangs up ; NOT RESPONDING.

[Red fuji]

The VBA runs fine with less data (less columns) but now it has much more data - about 1,000 columns that it has to calculate. seems like it is running but when i check the Windows Task Manager Excel is NOT RESPONDING then I have to Ctrl-Break to get it going again but then it never stops running and seems like it wants to run for hours or days.
What does it need to successfully run and not hang up ?

[ajryan88]

I can't tell which of the subroutine's is the master (although I presume it is Get_User_Input). At the start of the master subroutine (or wherever your code entry point(s) is/are), insert a

Please Login or Register  to view this content.

and at all exit points of the code, insert a

Please Login or Register  to view this content.

I hope this helps