I don't know how automated you want this but the fastest and easiest way is
to use a filter. Go to Data-Filter-Auto Filter. Then just select the column
you want to search using "Custom" in the drop down list. Or if you do need
the code it's -

In the example below I'm looking for any cells that contain "Min" any where
in the cell.

Selection.AutoFilter
Selection.AutoFilter Field:=13, Criteria1:="=*Min*", Operator:=xlAnd

Hope this helps.

"xmis1" wrote:

Hello,



Here is my issue.

I just did an export of the permissions of my all the public folders to an
excel spredsheet. We have about 2500 public folders, therefore row in the
spreadsheet. My issue is that I need to parse the spreadsheet based on a
string (like using grep in a unix) and get back the line where the string
appears. Can this be done by a vbscript? Does someone have a tools or a
script that can help.



Thanks