Unique list maker with inputboxes with from and to

Hi!

I'm trying to get my macro:

Please Login or Register  to view this content.

to work where inputs are from 2 different inputboxes

Input box A should be connected to "c = Range("A2:A" & lr)" as this is from where the non-unique values are and input box B should be connected to "Range("B2").Resize(d.Count) = Application.Transpose(d.keys)" which is where I want the output, but I can't get it to work as I'm not that familiar with macros with inputs from input boxes

This is what I've tried but get errors from it

Please Login or Register  to view this content.

Originally Posted by WideBoyDixon

Try like this:

Please Login or Register  to view this content.

WBD

Thanks a lot, this solved my issue and you made the macro a bit smaller