Identify multiple selected cells
Posted by Erica on August 14, 2000 11:19 PM
I want to identify multiple selected cells within a macro (alternative is to use a drop down list box with multiple select option set, but I can also not figure out how to identify which was selected, and this is not the first choice). I typically want to check a fixed range by running through the cells in a loop and check if each cell is selected or not ie. cells(r,c).selected = true. How can this be done? There is no property .selected.