HI,

A suggestion for sheet1 is to have the data in column A in it's own row.
Code wise would be simpler.
I'll look at this and see what I can do. If any other member wants to pitch in that would be fine.

Note: you mentioned "deselect" I think you wanted to select. Also what do you want to do with the selection?