On Oct 17, 2:08 am, "Crowbar via OfficeKB.com" <u15117@uwe wrote:
Rather than check how much memory you have used. You might want to consider
how much memory is free.

At the point the think the module fails insert this code and it will tell you
how much memory is left available

MsgBox Application.MemoryFree

If this doesn't work, try it in other areas of the code

It might help

wrote:
Hello

I have a big worksheet and I think I have a memory problem with some
modules

Some result are very strange

I think than a module or a sheet have a limit memory size ?

How I can know the memory use by some VBA module or Sheet

Thanks

--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-programming/200710/1

Hi Crowbar,
I have tried
MsgBox Application.MemoryFree
in a new work book containing only this statement and worksheet blank.

I am getting a reply msgbox with a number 1048576.

What does it mean?

Regards,
Madiya