returns position in text

 
    =FIND(<criteria>, <text to search>)

    =SEARCH(<criteria>, <text to search>)
    

 
    searchFor = "..."
    For Each cell In someRange
        If instr(cell, searchFor) <> 0 Then
            ...
        End If
    Next cell
    

the code below uses the Evaluate function
write 1 to cell C:10

 
    [c10] = 1
    

both lines belwo return the same result

 
    myVar = Evaluate("SUM(D1:D10)")
    myVar = Application.WorksheetFunctionSum(Range(D1:D10)")
    

can use to set range

 
        [D1:D10].Select
    

can use with named range
line below sets cell in range to 23

 
    [<named range>] = 23
    

ALT + Equals

 
    =SUM(<range>)
    

in VBA

        
    [f2] = Application.WorksheetFunction.Sum(Range(C:C))
            

(C:C) range includes the entire column C

Count function just counts anything which is a number

  
    [f3] = Application.WorksheetFunction.Count(Range(C:C))
    

CountA function counts rows

  
    [f3] = Application.WorksheetFunction.CountA(Range(C:C))