2 comments:

Hi ShwetaEarlier, this afternoon I sent you a message. But I doubt about message procedure. So I sent you my question again: I copied your VBA code for a Data Validation with Unique Values. but I have an error on row: 'ReDim distinct(....)' So, I would ask you, please will you send me a Excel model as Example. I thank you very much for your answer. With regards,Bert van Zandbergen, Beekbergen The NetherlandsEmail: klvzndbrgn@gmail.com

Thank you for this helpful tip. I just wanted you to know that it was very helpful to me to use this in my project to create a list of unique values which are then used in a dynamic named range as a drop down menu to then be used as a report filter.