List all selected cells in a Excel

Hello,

what do you mean with "show all selected cells"? If you select the cells, you can already see them, so in what way do you want to "show" them?

Can you explain what you want to achieve? What is the bigger picture?

cheers, teylyn

Suppose the 3 cells in the attached file is selected, how to collect the values of all cells when I run the macro ? I want to do some calcuation for them.

Tks
selectedCells.png

You could use a for/each loop along the lines of

Dim cel As Range

For Each cel In Selection
    ' your calculation, for example assign a value to each cell
    cel = cel.value * 1
Next

Select allOpen in new window

Tks