is there anyway to check your system resources in VBA code? I'd like to insert a section into a macro that stops the macro if resources (RAM) gets too low. the reason is that i periodically get an error message like "out of memory" in the middle of my macro.