Hiding selected columns

I am looking for a method to hide selected columns in a 69 column spread sheet. Kind of like a filter. There are 32 columns and each has an adjacent column. Then there is a name, number and group column and finally a total column. For example there is a column titled "22 Western Pleasure, Sr." and adjacent to that is "Points".

I thought of using a find to search for each occurrence of "Sr." and hide that column and the next. Of course I need to unhide those columns also.

1. Does find (in code) return a true or false?
2. When find executes how does code know it has accomplished anything?
3. How do you know when to code for "find" and "find next"?
4. Is there an "unhide all" method.

Some input from the gurus will be greatly appreciated.

1,3) The VBEditor Help system explains the .Find and .FindNext functions.

2) If the search term is not in the indicated range, .Find returns Nothing.

4) Click the diamond in the upper-left corner the entire sheet will be selected. Format>Columns>UnHide will unhide all columns. The Macro Recorder will return the code to do this.

If you have problems getting your code to do what you want, post again and we'll help you set things right.

Thanks for your response. I'll be trying this later today to see what happens. Hopefully I wont need to post.