Delete cell contents without breaking formulas

Hi Guys,
I have a sheet that has data generated on it by button click that calls a macro (thanks Watersev!!). Formulas on other sheets then use this data in a number of ways including producing plots and charts. My problem is that every once in a while someone will wish to clear all the data and enter a new set. So I'm using the following code to clear the cell contents so that new data can be added:

Please Login or Register  to view this content.

This certainly clears the cells contents, but it also breaks all of the formula references to the cells where the data used to be.

So in step-by-step:

• Sheet starts blank
  Button is pressed and sheet is populated
  On another sheet the tables and charts are populated from the data
  The 'delete' button is pressed and the inital data sheet is cleared
  All formulas that linked to the inital data sheet break and become #REF errors

Does anyone have any ideas on how to prevent this from happening. I've tried making the formulas INDIRECT as other have said this will work, but it doesnt!

Have you tried clearcontents instead

Please Login or Register  to view this content.