View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] staeri@gmail.com is offline
external usenet poster
 
Posts: 35
Default Loop and extend selection

I have the following values in the A column:
1
2
2
2
3
3

I want to loop through the values by starting in cell A1 and extend the
selection as long as the values are the same. That means in the above
example that all the cells with the value 2 should be selected. How can
I do that?

I'm very grateful for fast answer!

Regards,

S