I can't seem to find a VBA command that returns the memory in use or the memory available. In Excel 2013 there was Application.MemoryUsed but when I try that in Excel 2016 I get "Type mismatch", regardless if I use
dim myVar as variant
myvar = Application.MemoryUsed
or
MsgBox CStr(Application.MemoryUsed)
It's probably a simple thing. Or?
I found the answer shortly after I put the question.
found here: https://social.msdn.microsoft.com/Forums/office/en-US/e3aefd82-ec6a-49c7-9fbf-5d57d8ef65ca/check-size-of-excelexe-in-memory?forum=exceldev
Thanks to Anonimista!