View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Khai[_2_] Khai[_2_] is offline
external usenet poster
 
Posts: 7
Default Need help with Search

I need some help with a search routine.

I need to search through Column B (dynamic # of rows), for spreadsheets that
the tabs are named after months.

(June, July, august, etc..) Which is basically each tab except for one
called Dr. Refs. I need it to search for a string within those cells in
Column B, and keep an array of those Sheets:CellLoc's..

If I can get a search going, I'm sure I can do the rest. Excel 2000, and
Excel XP, any help appreciated.

Thanks very much. =D
-khai