View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default non-contiguous range

Hi All,

I want to select a non-contiguous range but with the restriction that it can
contain only one cell from each row. Is it possible to unselect all other
cells in the row when I add a new cell of the same row to the range. The
problem is that Ctrl-Click doesn't trigger Selection_Change event to give me
opportunity to reformat my range on the fly!

Regards,
Stefi