Trigger Code with Mouse Click
I think it's going to be tough to figure out how a range was selected. I
might be inclined to have users double-click a cell, and then use the
Worksheet_BeforeDoubleClick event.
Btw, it might be more efficient to make your array a public variable and
populate it just once, say during the Workbook_Open event, rather than every
time a cell is selected.
--
Jim Rech
Excel MVP
|