Hi does anybody have any infromation how I can have a list box selection related to a range.
e.g. the names I want to appear in a list box are in columns A11

and for each select say A1, I want the range of A2:A19 to be read into an array, and this done for any selection, it can be multiple selections.

Many Thanks