title: How to use VBA to clear content?
body: <p>I would like to have all cells empty after opening my spreadsheet on &quot;ThisWorkbook&quot;.</p>
  <p>Code:</p>
  <pre><code>Sheets(&quot;1 - Feuille de Suivi&quot;).Range(&quot;C19&quot;) = &quot;&quot;
  </code></pre>
  <p>and</p>
  <pre><code>Sheets(&quot;1 - Feuille de Suivi&quot;).Liste_cible.Clear
  Sheets(&quot;1 - Feuille de Suivi&quot;).Liste_cible.Value = &quot;&quot;
  </code></pre>
  <p>But it takes a little time before deleting, so I can see the data after opening (1-2 seconds) and it is deleted after.</p>
  <p>Maybe you know some efficient function VBA that deletes the data while opening the spreadsheet ?</p>
  <p>Thank you very much for your help !</p>