Excel VBA RemoveDuplicates not working as expected

I am using code such as the following:

Range("A1:B17").RemoveDuplicates Columns:=1

When I run the code (see attached workbook) the "Columns:=1" part of the code seems to be ignored - and only rows where both A and B match are removed not sure why the VBA behavior does not match the GUI behavior.

It does seem to be an issue only with Office for Mac - I am currently using Excel for Mac 2011 version 14.4.3 (140616) and it does not have this issue with Excel for Windows 2007 version 12.0.6683.5002 SP3 MSO 12.0.6683.5000
Also tried it on Windows Office 2010 and it works as intend.

I tried it on three different Macs - all with 14.4.3 same build without success. I don't currently have any other versions loaded up to test it on.

I develop on Mac but need to maintain compatibility with both Mac and Windows versions as I have users on both.
If I cannot get this working I may have to resort to much more complex looping type code.


RemoveDuplicatesVBA.xlsm

cross post at - http://www.mrexcel.com/forum/excel-q...-expected.html