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.

Please Login or Register  to view this content.
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