Not enough memory ,message

I have a worksheet using the rand() function and 3 macros.When I cycle through the macros on the 5th attempt I get the above message. Is there a function where I can clear the memory without exiting Excel.

Regards,

Harry

Make sure the zoom setting under view is at 100%

--
Regards,
Tom Ogilvy

"Harrymo" <Harrymo.224ppm_1138089301.6494@excelforum-nospam.com> wrote in
message news:Harrymo.224ppm_1138089301.6494@excelforum-nospam.com...
>
> I have a worksheet using the rand() function and 3 macros.When I cycle
> through the macros on the 5th attempt I get the above message. Is there
> a function where I can clear the memory without exiting Excel.
>
> Regards,
>
> Harry
>
>
> --
> Harrymo
> ------------------------------------------------------------------------
> Harrymo's Profile:
http://www.excelforum.com/member.php...o&userid=30620
> View this thread: http://www.excelforum.com/showthread...hreadid=504336
>