auto erase data

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?

messiah166,

Yeah, a worksheet change could do it, though it would run far more often than necessary. From your description of closing and opening the workbook, I'd put it in the Workbook_Open event.

~tigeravatar