Need to blank out all the cells in a worksheet [duplicate]

Question

• I have a production workbook with a display sheet that references multiple sheets of weekly raw data.

• I've written a VBA macro to replace all of the weeekly raw data sheets, but in order to simplify things I had to do this:

  AssemblyBook.Sheets("IB").Range("A:A").EntireRow.Delete  ' Blow away the entire sheet
  

• The problem is, all of my cell references in the display sheet show #REF if I execute the macros inside the production workbook. I have to import the sheets into a separate workbook called AssemblyBook, and then Paste/Values the raw data sheets from the AssemblyBook into the sheets in my production workbook.

• I'm trying to find a way to just blank out all of the raw data values in my production workbook so I can execute the macro within my production workbook. That way, I can skip the copy/paste from my assembly workbook into my production workbook.

Thanks...