Are you sure you have put me.calculate in the "Worksheet_Change" event and NOT the "Worksheet_SelectionChange" ?