Macro to count unique values in a column with pop up message box - sheet will be filtered

Hi,

I'm trying to find a way to count the unique values in a specific column. I'd like to have a macro where I press a "Count" button and a message box pops up with the number. The sheet will be filtered based on values in other columns and the number of unique values will need to reflect the updated total.

I've attached a sheet with the unique values that need to be counted in column E. The sheet will be filtered by column B.

If you have any suggestions or advice, I'd really appreciate it. Thanks!

Graham

Thanks, Pierre! That second macro is exactly what I needed. The first code is counting the visible cells with values but the second one is counting the unique values and works perfectly.

Thanks again!
Graham