Remove Duplicates in Excel Macro

[sam1986]

Hi All

I have written code which will remove duplicates based on condition. Which works perfectly in Windows. But when i send this file to my friend who is using Mac it throwing errors. I am not sure how to rectify. Also i saw in google, normally excel code will work in both Windows and Mac. I haven't worked with Mac till now. I don't know to debug as well.

Can any one let me know is there any issue with my code, so that it doesn't support mac. I saw one error related to autofilter. for me it looks ok.

Here is the file.

 

[vletm]

sam1986
If You hide .Autofilter as below then it won't give 'error'

.. but ..
do this give any needed results after that...?
( I do not comment other things from Your code! )

 

[sam1986]

sam1986
If You hide .Autofilter as below then it won't give 'error'
View attachment 70065
.. but ..
do this give any needed results after that...?
( I do not comment other things from Your code! )

Ok Vletm, Let me try by commenting Autofilter Line.

 

[sam1986]

Ok Vletm, Let me try by commenting Autofilter Line.

Its working, thanks VLetm