This example replaces every occurrence of the trigonometric function SIN with the function COS. The replacement range is column A on Sheet1.
Worksheets("Sheet1").Columns("A").Replace _
What:="SIN", Replacement:="COS", _
SearchOrder:=xlByColumns, MatchCase:=True