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

What exactly are the symptoms? What is your code? What results do you get? What makes you think it is a memory problem?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in message ups.com...
|
| 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
|

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.com
http://www.officekb.com/Uwe/Forums.a...mming/200710/1

Rumour has it that VBA modules get flaky when they reach 64k when
exported as a text file

Have you tried codecleaner (free) by Rob bovey? Its got me out of
trouble plenty of times

http://www.appspro.com/Utilities/CodeCleaner.htm

Cheers
Simon
Blog: www.smurfonspreadsheets.net
Website: www.codematic.net Excel development, support and training


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

Unless you are using Excel 2007.

MemoryUsed, MemoryFree, etc. are no longer Properties/Methods of the
Application object (with no equivalent provided) and use of them will cause
an error.

Found that out the first time a user fired up 2007. Nice surprise. To my
knowledge it's not actually mentioned anywhere that they were intentionally
depreciated, they are simply absent from the object model.


"Crowbar via OfficeKB.com" <u15117@uwe wrote in message
news:79cb2f4f45a81@uwe...
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.com
http://www.officekb.com/Uwe/Forums.a...mming/200710/1

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

On Oct 16, 7:11 pm, Simon Murphy wrote:
Rumour has it that VBA modules get flaky when they reach 64k when
exported as a text file

Have you tried codecleaner (free) by Rob bovey? Its got me out of
trouble plenty of times

http://www.appspro.com/Utilities/CodeCleaner.htm

Cheers
Simon
Blog:www.smurfonspreadsheets.net
Website:www.codematic.netExcel development, support and training



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- Hide quoted text -

- Show quoted text -

Hi Simon

Effectively, I have a Vba Sheet over 64k ...

I try CodeCleaner

Thanks

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

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