text string seach and count???

[Matthew Recknagel]

Alright i have a term i want to search say "Large Dog"
I have a list of about 200 rows of files (located in a few main folders on my computer) that i want to search through each of the text strings.
Is there a way that i can search through the entire list and have the formula return return a count of how many files have "Large Dog" in them

Optional: I know for a fact that the files that have persay "Large Dog" in them all reside in the same folder, is there a way to return the count of how many files there are with a hyperlink to that folder?

Thanks so much in advance, will respond if any additional details are needed!
Matt

 

[pbornemeier]

This code will generate a hyperlink to each folder listed in column A of the activesheet. Warning: it will first delete all hyperlinks on the active sheet.

Sub CreateColumnAHyperlinks()
    Dim lX As Long
    Dim lLastDataRow As Long
 
    For lX = ActiveSheet.Hyperlinks.Count To 1 Step -1
        ActiveSheet.Hyperlinks(lX).Delete
    Next
 
    lLastDataRow = Cells(Rows.Count, 1).End(xlUp).Row
 
    For lX = 2 To lLastDataRow
        ActiveSheet.Hyperlinks.Add Anchor:=Cells(lX, 1), Address:=Cells(lX, 1).Value, _
        TextToDisplay:=Cells(lX, 1).Value
    Next
End Sub

 

[Matthew Recknagel]

Thanks for all your help! I really appreciate it! I will have to give your code a try here soon, (New assignment has come to me) and will give it a try afterwards! will let you know when i do.

Thanks again!
Matt