UNIQUE function doesn't always work

[ajaykgarg]

Hello All

I am using UNIQUE function in VBA to get unique values from a column to another column, something like:

Please Login or Register  to view this content.

This morning, users reported a bug and I found that in column A, ALL values from 7th column were present, instead of just the unique values.

I set up a breakpoint, and again saw the same issue.

So, I manually (not through VBA code) use the unique function on the worksheet in another column, and see the same issue.

Then, I close the file, reopen it and the unique function magically starts working properly in all these places!

Now, it ALWAYS works and I am not even able to recreate the issue!


1. Is there a known issue with unique function, and if so, is there a workaround?

2. I have now added

Please Login or Register  to view this content.

function after unique function in my vba code. Will that help, or should I do something else to "force" unique function to work every time?


Thanks All
Ajay

[dangelor]

A different approach...

Please Login or Register  to view this content.