title: Find and replace all occurences of a string in a range
body: <p>I want to basically simulate the replace all feature in Excel inside VBA and replace the string 03/01/2018 (which exists 10 times in this workbook) with 01/03/2017 I already figured out how to do that for one single occurrence but not to all occurrences inside a range.</p>
  
  <p>Is there something like findnext for the replace method?   </p>
  
  <pre><code>Sub findandreplacedate()
      Workbooks("01 .xlsx").Sheets(1).usedrange.Replace What:="*03/01/2018*", _
      Replacement:="01/03/2017", LookAt:=xlPart, _
              SearchOrder:=xlByRows, MatchCase:=False
  end sub
  </code></pre>