Hi,
I am facing "Run-time error '28' out of stack space" in solution provided under Title "Record Number of sum to formula based cell - Excel".
Can I request to please provide solution for the same.
Regards,
Hi,
I am facing "Run-time error '28' out of stack space" in solution provided under Title "Record Number of sum to formula based cell - Excel".
Can I request to please provide solution for the same.
Regards,
Sunil
There could be several reasons for this error (when your PC runs out of RAM)- do a Google search for causes and possible fixes.
It's impossible for us to work out the cause since that previous answer is a fairly simple macro but deals with changes to a remote file (by some means). It disables events to prevent retriggering but if you linked the files so the macro file then changes the remote file which triggers the macro again, you might cause an uncontrolled cascade of events.
Other causes might be recently installed software or a virus (and I note your recent unanswered question relates to a new Add-in - have you tried un-installling that?