Rob Zwanenburg
New Member
dear fellow excel-users,
I am dying to have solutions for my problems, which make my work very difficult indeed! I get the error message "excel ran out of resources..." every time. I believe it is related to the use of both volatile functions and array formulas. The background is easy. I use two 'check-rows' and the top of worksheets to check if there are no errors or really empty cells in large worksheets. I added a workbook where you can see the formulas used.
Who can has ideas how to get around using volatile and array formulas without losing the flexibility these offer?
Thanks in advance!
Rob
I am dying to have solutions for my problems, which make my work very difficult indeed! I get the error message "excel ran out of resources..." every time. I believe it is related to the use of both volatile functions and array formulas. The background is easy. I use two 'check-rows' and the top of worksheets to check if there are no errors or really empty cells in large worksheets. I added a workbook where you can see the formulas used.
Who can has ideas how to get around using volatile and array formulas without losing the flexibility these offer?
Thanks in advance!
Rob
