Hi,
I have been looking in the forum if anyone have found a solution to the problem when using remove duplicates in Excel for Mac 2016 a popup window appears that doesn't allow the code to continue. I have spent some time looking for a workaround and it seems that issue hasn't been resolved, any suggestions?
The code I used to use in Excel Mac 2010 was ActiveSheet.Range("B2:B30000").RemoveDuplicates and worked perfectly but when I tried the same code in Excel Mac 2016 a popup window appears asking to choose the column
Thank you so much
I have been looking in the forum if anyone have found a solution to the problem when using remove duplicates in Excel for Mac 2016 a popup window appears that doesn't allow the code to continue. I have spent some time looking for a workaround and it seems that issue hasn't been resolved, any suggestions?
The code I used to use in Excel Mac 2010 was ActiveSheet.Range("B2:B30000").RemoveDuplicates and worked perfectly but when I tried the same code in Excel Mac 2016 a popup window appears asking to choose the column
Thank you so much
