View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jean-Yves[_2_] Jean-Yves[_2_] is offline
external usenet poster
 
Posts: 253
Default Strange or error : For each cl in Selection 'cl as range

Hi All,

I found the following really strange :
if you make a multiple selection with the mouse while holding down <CTRL,
and ,
if you Re-select a previously selected cell, this will also re Add this
cell to the selected range.

Result : <For each cl in selection gives me the same range more than once
!!!
In the immediate window :
? selection.address
$CV$14,$CV$14,$CV$14,$CV$14,$CV$14,$CV$14,$CV$14,$ CV$14

Question : is this normal, and if yes, who can I filter this list-array to
avoid duplicated entries.

Regards,

Jean-Yves