Get Text From Selected Cells in Excel Worksheet

[YerMom]

Hi.

I need to get the text of selected cells in a worksheet. How do I identify the cells in the selection?

I can probably extract the text in the cells, but I don't know how to programmatically determine which cells are selected.

Let me know if that did not make sense.

Thanks.

 

[PHV]

Why not playing with the Selection object ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SkipVought]

Hi,

The Selection Object is the selected range.

dim r as range
for each r in selection
  msgbox r.value
next

Skip,

_[red][/red]