hi guys,

i recorded a macro that selects a sheet, highlights a table that is created from a MS query, then removes duplicates, then displays a msgbox to inform the user.

Sub Macro6()
'
' Macro6 Macro
'

'
    Sheets("Raw Data").Select
    ActiveSheet.Range("Table_Query_from_SFS[#All]").RemoveDuplicates Columns:= _
        Array(1, 2, 3, 4, 5, 6, 7, 8, 9), Header:=xlYes

End Sub
the problem i have is i am calling this macro from another procedure, which works fine, but and the msgbox displays "Duplicates Removed" but it doesnt actually remove duplicates because i can manually goto the sheet after the procedure has finished and remove duplicates still, it the marco was working there would be no duplicates left and would get a msg saying that.

any help would be appreciated