title: SImple macro to delete all unused columns and rows
body: <p>I have linked a spreadsheet to a database and have created a macro that clears the contents of the worksheet and pastes In the results of the SQL I send to the database. </p>
  
  <p>It returns about 30 columns of data with about 6000 rows of data, yet the file size ballooned to 22mb!? I read on here about deleting/hiding empty columns and cells and this reduced the file to 2.5mb.</p>
  
  <p>Is there a quick macro that will save me having to do this manually each day please? I've seen a lot of variants on Google and I can't get one to work correctly.</p>
  
  <p>The number of columns stays the same each day but the number of rows fluctuate.</p>