You could create a userform on the fly and populate a listbox with the
list of named ranges from your worksheet. Seems like a big project
though.


HTH,
JP


On Mar 3, 4:45*pm, snax500 wrote:
I wanted to have it within the macro so that a listbox pops on the
screen, the user chooses the name and then my macro takes the user
picked name and filters the data. I did not want data validation.