title: Macro issues across Excel versions
body: <p>I've got a macro-enabled workbook that works just fine in Office365's version of Excel but earlier versions are breaking all over the place. If anyone could provide direction, I would appreciate it!
  The current issue is with this bit below:</p>
  <pre><code>Range(&quot;1:1&quot;).Select
          Selection.Find(What:=&quot;eventdate&quot;, After:=ActiveCell, LookIn:=xlFormulas2, LookAt _
              :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
              False, SearchFormat:=False).Select
          Range(Selection.Offset(1, 0), Selection.Offset(1048570, 0).End(xlUp)).Select
          Set rng = Selection
          For Each eventdateCell In rng
              eventdateCell.NumberFormat = &quot;@&quot;
              eventdateCell.Value = WorksheetFunction.Text(eventdateCell.Value, &quot;yyyy-mm-dd&quot;)
          Next eventdateCell
  </code></pre>