Hi is there any way to get the memory used by code, so that I can write it to
a text file. I have checked out the history on this group but can't find
anything on this subject?.
TIA
Charles

Try this:

Sub ShowMemoryUsage()

Dim dMemUsed As Double

dMemUsed = Round(Application.MemoryUsed / 1000, 1)

MsgBox "Memory used: " & dMemUsed & " kB", ,"memory usage by Excel"

End Sub


RBS


"vqthomf" wrote in message
...
Hi is there any way to get the memory used by code, so that I can write it
to
a text file. I have checked out the history on this group but can't find
anything on this subject?.
TIA
Charles

Whilst these memory properties are available, I have seldom seen them have
much meaning apart from "a lot" or "not much".
Also, there is lot going on in the background of Excel, that you can't
control, so it's debatable how accurate they would be at any specific
instant.

NickHK

"RB Smissaert" wrote in message
...
Try this:

Sub ShowMemoryUsage()

Dim dMemUsed As Double

dMemUsed = Round(Application.MemoryUsed / 1000, 1)

MsgBox "Memory used: " & dMemUsed & " kB", ,"memory usage by Excel"

End Sub


RBS


"vqthomf" wrote in message
...
Hi is there any way to get the memory used by code, so that I can write
it
to
a text file. I have checked out the history on this group but can't find
anything on this subject?.
TIA
Charles