title: Excel VBA - RemoveDuplicates method does not work with Mac
body: <p>I have below piece of code to remove duplicates from a sheet by looking into two columns (column 3 &amp; 5).</p>
  
  <pre><code>lRow = .Cells(Rows.Count, "A").End(xlUp).Row
  '.Range("A1:BR" &amp; lRow).RemoveDuplicates Columns:=Array(3, 5), Header:=xlYes
  .Range("$A$1:$BR$" &amp; lRow).RemoveDuplicates Columns:=Array(3, 5), Header:=xlYes
  </code></pre>
  
  <p>It works fine in Windows but unfortunately not on Mac.</p>
  
  <p>Can anybody please suggest me what do I need to change here?</p>