If you dim mvarray in the sub it is destroyed when the sub closes. If you dimit outside the sub in a module (not in a worksheet or workbook) it lasts untilyou close the workbook the module belongs to.