getting selected rows row by row

[Holger Beese]

Hi,

i have an excel sheet, where the user have to select one or more rows to
I have to do something with it. But I can only do it row by row. So if
the user select one row only, everything is fine. But if the user select
more then one row, as I mentioned before, I have to do the work row by
row. The question is, how can I see, if a row is selectet??? *grmpf*
ActiveWindow.RangeSelection.Address gives me all the selected cells.
This doesn't help me much. I need somthing like this:

....
if [any special row].selected then
...[do my work with this special row]
endif
....

But the attribut selected seems not to exist. How can I get the
information, if a row ist selected or not?

THX,

H. Beese

 

[Doug Robbins]

Better to ask this question in microsoft.public.excel.programming

This group is for Word

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP