Excel Crash on Insert Row, and Cut and Paste

[Jaamie]

Weeks into a project, all of a sudden VBA cutting a row and inserting it, or even cutting a range of cells and pasting them are both causing Excel to crash. I have created a clean workbook and tried suggestions from searching the web. Nothing works! Stepping thru is fails on the Insert command. In the cut and paste it fails on the Paste. This code has worked in the past.

I am using Office 2016 on Win 10.

This is Function that moves transactions into date order. If I use a test Subroutine that just calls the function; it works.

Any ideas are welcome.

 

[Joe4]

Typically, from my experience, if something that has worked for a while all of a sudden stops working, it is often due to some change in the data file (structure or perhaps size of the data).

With what you give us, there is a little we can do. But if you post your code here, and some sample data, we may be able to help you.

 

[Jaamie]

Thank you for the reply. I have a solution but not sure why. The call to the Function was made from several levels down. (ie, Sub, then Function A, Function B, then call to my date move Function) I reordered things and moved it to the top level. Ie A call from a Subroutine. and it worked.

Is there a way to determine how deep the Stack is from within the VBA code?

 

[Joe4]

Is there a way to determine how deep the Stack it from within the VBA code?

I am sorry, but I do not know. I have never seen anything like that, and I have never tried to do anything like that.