VBA to remove duplicate entries in a column

Hi all,

I have names of our employees in column A that is being populated from another spreadsheet using "If" formulae. I need to delete the duplicate entries and also delete the row. For this I am trying the following VBA code, but running into problems. The code is stopping at the "Lastrow" line with a run-time error message 438- "object doesn't support this property or method". Any help would be greatly appreciated.

Also I would like to delete the rows with blanks in this column.

Please Login or Register  to view this content.

Thank you trebor76.

I found this solution elsewhere online and seems to work well for me.

Please Login or Register  to view this content.