I see the problem. If I manually run the macro it erases. But its not auto erasing when the sheet is closed and reopened. Incorporate it into a worksheet_change?