how to check memory used for a particular sub?

[bsapaka]

Is there a simple way to do this?

[dingdongsilver]

You can open the work book then look at the memory usage of the process in task manager. Run the sub and watch what the process balloons to. Then subtract out the maximum used during the sub from the standard memory used while having the workbook freshly opened. Not perfect but it will give you a rough idea.