Listbox import other worksheet multiple ranges

Hi excel Forum friend's!


I have the following macro:

I want that amount ranges "A2:D" (Multiple range), but only shows me the 1st column ("A"),

When make changes, I get only first value in column listbox, not the 4 columns that I need ..

someone could help me?
Thank you!
Best Regards!!

Please Login or Register  to view this content.

Range "A2:D" is not a valid range reference.

Try something like this...

Please Login or Register  to view this content.

Great Job!!.. thanks again AlphaFrog!..

Best Regards!