View Single Post
  #2   Report Post  
Kirchberger
 
Posts: n/a
Default

Hi 1stpope,

Try this... If you do a find and click on "Find All", you should see
the dialog expand to show a list of the cells. The first of these will
be highlighted. Scroll down to the end of the list, hold down the Shift
key, and click the last cell listed. You should now see that all your
"found" cells have been selected. At this point you can close the
dialog and dow what you need to do.

As for the column reformatting, that would take some VBA and some
understanding of what defines your groups. It might be complex...

Regards,

Gary