![]() |
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