title: Excel VBA select entire sheet using Range
body: <p>I am using the following code to search through a sheet to find out how many times does the word 'example' appear.</p>
  
  <pre><code>count = Application.WorksheetFunction.CountIf(Range("A1:A10"), "example")
  </code></pre>
  
  <p>I can't seem to figure out how to iterate through the entire sheet using the Range function.</p>