JimS

01-21-2009, 01:27 PM

Does anyone have any code that can delete all formulas that are not using used.

I have a sheet called "Input" that gets populated via an Import of a .csv file.

On a sheet called "Data" I have references to the "Input" sheet via the following formula:

=IF('Input'!$A$1="","",'Input'!$A$1)

This formula is replicated down to row 300 (Cell A300) on the Data sheet.

On the "Input" sheet there is only 30 entries - this time, it can vary up to 300 entries.

How can I delete the "unsed" formulas that are in A31:A300 on the "Data" sheet?

This might not be the best way but eventually I'm trying to have the Charts that reference the "Data" sheet automaticlly adjust the Source Rows to match the number of entries on the Input (or Data) sheet.

Thanks for any and all help...(God knows I need it)

Jim

I have a sheet called "Input" that gets populated via an Import of a .csv file.

On a sheet called "Data" I have references to the "Input" sheet via the following formula:

=IF('Input'!$A$1="","",'Input'!$A$1)

This formula is replicated down to row 300 (Cell A300) on the Data sheet.

On the "Input" sheet there is only 30 entries - this time, it can vary up to 300 entries.

How can I delete the "unsed" formulas that are in A31:A300 on the "Data" sheet?

This might not be the best way but eventually I'm trying to have the Charts that reference the "Data" sheet automaticlly adjust the Source Rows to match the number of entries on the Input (or Data) sheet.

Thanks for any and all help...(God knows I need it)

Jim