it was removed in 2007. no longer available.



wrote in message
ps.com...
On Oct 16, 5:08 pm, "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

__________________________________________________ ______________________

Hello


I use Excel 2007 and I try MsgBox Application.MemoryFree

I try it at different places and I have the same problem "Type
incompatibility"

In the Help file, for Application I don't found Event, property
or Methods for Memory

Thanks