Delete Unique Values Macro Skipping Some Values

Hi,

I have two Macros that Delete unique Values:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

both of them give inaccurate results.

I make sure I Round the values to 4 decimal places so my data is uniform but still these macros delete some duplicate values and I can't have that.

Can you see where they go wrong or how they can be improved?

Which one is the better approach?

Thanks for any help.

Here is some sample coding that will delete rows in which column A contains unique values as displayed.

Jakobshavn,

Now there's some programming. I like your style. I'm just a hack myself. I've put together a huge stock analysis program in Excel that's too sluggish to get through stocks with lots of data. I'll need to streamline it if it's profitable. Can I keep you in mind for some extra cash when that time comes?

If you need help, mine is free (and a bargain at twice the price!)

That rocks. Rowkiller works great. I'd like to try an alteration. Can you have a look at:

http://www.excelforum.com/excel-prog...92#post3254192