Multiple Cell Selection Coordinates

[EliasEMS]

Hello,

How can I get coordinates for multiple selected cells? I know it is possible with one cell selected by using "selection.address". How would it work if I had more than one cell selected?

Thank you!

 

[ZAX]

The Selection.Address Property Works Even If The Selection Is Multiple Even If You Press Ctrl And Highlight Multiple Ranges!
ZAX

 

[Rick Rothstein]

The Selection.Address Property Works Even If The Selection Is Multiple Even If You Press Ctrl And Highlight Multiple Ranges!
ZAX

Just to add to ZAX's comment... the Address property can take optional arguments, so I would recommend you use Selection.Address(0,0) in order to get rid of the $ signs in its output. Also, the string argument for Range is limited to 255 characters, so doing this will also allow more addresses overall to be returned to you.

 

[EliasEMS]

Thank you guys! That works perfectly. So now I get multiple coordinates, how do i refer to each individually?

For instance, I will run a macro for each coordinate, how do I take only the first coordinate returned, and then the second?

Thank you very much!

 

[EliasEMS]

Thank you! That works perfectly. So now I get multiple coordinates, how do i refer to each individually?

For instance, I will run a macro for each coordinate, how do I take only the first coordinate returned, and then the second?

Thank you very much!

 

[Jonmo1]

In that case, you don't need the address property of selection.
You need to loop through selection, then you can do whatever you want with each cell in selection.

For Each c In Selection
    MsgBox c.Address
Next c

 

[EliasEMS]

Perfect, thank you very much!

 

[Jonmo1]

Glad to help, thanks for the feedback.