tag:blogger.com,1999:blog-8528002828354636452.post4961269406199183561..comments2023-07-01T05:40:02.173-07:00Comments on Excel VBA Tips: CREATE DATA VALIDATION LIST WITH UNIQUE VALUES FROM A LIST OF DUPLICATESShweta Jainhttp://www.blogger.com/profile/06787782041357238346noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-8528002828354636452.post-89900687976567984442016-10-25T08:49:01.018-07:002016-10-25T08:49:01.018-07:00Thank you for this helpful tip. I just wanted you ...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.Muktukhttps://www.blogger.com/profile/11408947100940231834noreply@blogger.comtag:blogger.com,1999:blog-8528002828354636452.post-17099634791507106792013-10-21T08:49:43.696-07:002013-10-21T08:49:43.696-07:00Hi Shweta
Earlier, this afternoon I sent you a mes...Hi Shweta<br />Earlier, this afternoon I sent you a message. But I doubt about message procedure. So I sent you my question again: <br />I copied your VBA code for a Data Validation with Unique Values. but I have an error on row: 'ReDim distinct(....)' <br />So, I would ask you, please will you send me a Excel model as Example. <br />I thank you very much for your answer. <br />With regards,<br />Bert van Zandbergen, Beekbergen The Netherlands<br />Email: klvzndbrgn@gmail.comBerthttps://www.blogger.com/profile/04296960663135157478noreply@blogger.com