I have a file that has many data sheets and one sheet that calculates all the data from the other sheets. If a data sheet is empty, I have a macro that deletes it. I need a way to enter a $0.00 in the calculation cells on the main sheet for all deleted sheets.