Deleted sheets in calculations

lackeysl · Apr 1st, 2002, 06:35 AM

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.

Anne Troy · Apr 1st, 2002, 06:48 AM

What are you getting now? #REF?

Suppose your sheet said:

=Sheet5!B12

and you deleted sheet5 and now it says #REF.

You could put

=IF(ISERROR(Sheet5!B12),0,Sheet5!B12)

No?

Apr 1st, 2002, 06:48 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	What are you getting now? #REF? Suppose your sheet said: =Sheet5!B12 and you deleted sheet5 and now it says #REF. You could put =IF(ISERROR(Sheet5!B12),0,Sheet5!B12) No? __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 1st, 2002, 06:35 AM	#1
lackeysl New Member Join Date: Mar 2002 Posts: 6	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.