Advanced Filter - Unique Values Macro Returns 1st Value Twice

I apologize in advance if I have broken any of the thread or posting protocol for this site, but I have spent weeks searching forums for an answer on how to fix what is probably a very simple programming issue without any luck. I have tried various arrangements of code to get the same result pulled from different threads on excelforums.com.

I am filtering about 5,000 rows of data for unique values using a macro (command button) after completing a monthly SQL query. I need that data filtered and then copied to another sheet within the workbook. This part of the code I have posted below works, but I always get the first value twice.

Both the ranges "filter" and "DlrNo1" have headers, but when the macro runs and the data is filtered and copied from "DlrNo1" to "filter" the range name is changed to "extract" and the first value appears twice and also replaces the header name.

Thanks for your help in advance!

Please Login or Register  to view this content.

The range of data "DlrNo1" has a title/header. The header and range name are the same- "DlrNo1". Do the name of the range and header have to be different in order for this to work?

Fixed. I think what was causing the issue is that the header and the range name were the same. Once I changed the macro from "DlrNo1" to "P1:P10000" the issue was corrected. It is now working and I can go back to being a happy excel programming reverse engineer. Thanks for the help! I adjusted the code to:

Please Login or Register  to view this content.