ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Strange or error : For each cl in Selection 'cl as range (https://www.excelbanter.com/excel-programming/293046-strange-error-each-cl-selection-cl-range.html)

Jean-Yves[_2_]

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




All times are GMT +1. The time now is 07:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com