Macro to Extract Unique Values from Multiple Columns When Data Set Has Errors

[markp5]

Hi,

I found a macro online that provides a list of unique values from a multi-column selection. See below:

Please Login or Register  to view this content.

The macro works well, except when the data range includes #N/A. Is it possible to tweak this macro to provide a unique list of values from a range containing #N/A?

Sample workbook attached.

[Trebor76]

Hi markp5,

Try this which apart from dealing with cells in error from the selected range I've added Option Explicit, forcing all variables to be declared (two of which hadn't been) and built-in error trapping if Cancel is pressed on either of the two input boxes:

Please Login or Register  to view this content.

Regards,

Robert

[markp5]

This works like a charm. Thank you!

[Trebor76]

This works like a charm. Thank you!

You're welcome