I'd never come across this before and it doesn't appear in the IntelliSense drop-down, but it is quite a neat way of monitoring the current workbook size.
Per the MSDN page here:
This example displays a message box showing the number of bytes that Microsoft Excel is currently using.
MsgBox "Microsoft Excel is currently using " _
Application.MemoryUsed & " bytes"
No comments:
Post a Comment
Please, no purely anonymous comments, they will be deleted; always use a name for ease of reference by other commenters.