Steve,
Check out INSTR in the VBA help.
Or you have the worksheet function SEARCH for an Excel solution.

NickHK

"Steve" wrote in message
...
hi all,

your thoughts please?

I need to count instances of a text string, in this example "QR",
across my range. However the "QR" may exists within another string
eg. cell A1 - PROJECT 4338567 QR complete
cell a2 - 433756 testing QR

etc

the below is clearly wrong, but it may give you an idea of what I need
to acheive

for each cell in Range(cells(2, 2), Cells(20, 20)).Cells
if cell.value CONTAINS "QR" then
qrcount = qrcount + 1
end if
next
msgbox qrrcount

excel 97

any help appreciated :)
steve