MemoryTotal Property
Returns the total amount of memory (in bytes) that's available to Microsoft Excel, including memory already in use. Read-only Long.
Remarks
MemoryTotal is equal to MemoryUsed + MemoryFree.
Example
This example displays a message box showing the total number of available bytes.
MsgBox "Microsoft Excel has " & Application.MemoryTotal & _
" total bytes available"