Loop thru non-contiguous selection of cells

Hello,

I've been away from Excel VBA 2010 for nine months, and I need to be completely retrained! [sigh] Well, honestly, I probably couldn't have figured this out nine months ago either! And I'm having a heck of a time finding the answers in this forum!

My user would be on the MySheet worksheet. Let's say they select a cell in three non-contiguous rows: row 2, 5, 7.

My macro would then get initiated, and I want to loop through each of the three rows in turn, and take some actions based on values from each row.

Could someone get me pointed in the right direction please?

Thank you very kindly

Ya' don't mess with shg Texas! Just what I needed to thaw out my brain-freeze! Thanks so much!