My VBA is jumping to my worksheet in order to remove dups - how do I prevent this - here's my vba
Sub Deletedups()
Dim wsSOR As Worksheet: Set wsSOR = ActiveWorkbook.Sheets("Staffing_Open_Report")
Dim wsQue As Worksheet: Set wsQue = ActiveWorkbook.Sheets("Queues")
Application.ScreenUpdating = False
wsSOR.Activate
'Removes duplicates
Range("A1").Select
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
ActiveSheet.Range("$A$1:$S$2000").RemoveDuplicates Columns:=5, Header:= _
xlYes
Range("B1").Select
End Sub
Sub Deletedups()
Dim wsSOR As Worksheet: Set wsSOR = ActiveWorkbook.Sheets("Staffing_Open_Report")
Dim wsQue As Worksheet: Set wsQue = ActiveWorkbook.Sheets("Queues")
Application.ScreenUpdating = False
wsSOR.Activate
'Removes duplicates
Range("A1").Select
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
ActiveSheet.Range("$A$1:$S$2000").RemoveDuplicates Columns:=5, Header:= _
xlYes
Range("B1").Select
End Sub