I have two variables. StringA and StringB I want to be able to determine how many times StringA is in StringB.
For example...
StringA = "Cows"
StringB = "Doing work til the Cows come home, over the rainbow and in traffic Cows everywhere"
I thought this would mean, the instr would equal 2 in this example. It comes back zero everytime.
Code:If InStr(StringA, StringB) = 2 Then ws1.Cells(RowNum, 4) = "Filling out the datas" ws1.Cells(RowNum, 6) = "MORE DATA" End If
If not InStr, then what?