PDA

View Full Version : Eliminating Pop-up when using RemoveDuplicates



xxhhxx
05-01-2018, 06:29 AM
Hello,

Now I've googled a lot and tried to come up with a solution for how to remove the Pop-up box that comes when using the function 'RemoveDuplicates' through VBA. I've tried adding Application.DisplayAlerts = False and a lot of other stuff, but I can't seem to figure out how to do it..

Thank you,

/ P

Paul_Hossler
05-01-2018, 06:42 AM
No popups for me doing it this way



Option Explicit

Sub Macro1()
Worksheets("Sheet1").Cells(1, 1).CurrentRegion.RemoveDuplicates Columns:=Array(1, 2), Header:=xlYes
End Sub

xxhhxx
05-01-2018, 06:55 AM
Still comes up with the pop-up box..
22140

Aflatoon
05-01-2018, 07:08 AM
You should probably mention that you are using a Mac, and the many cross-posts you've made on this. ;)