I have a troubles with code to extracting whole word like "count" from cells
My column for search looks like:
A B
1 count |
2 count for games |
3 account with |
4 counting for |
5 count and something |

I need to extract to column B valies from A where word "count"
appear WHOLE :
A B
1 count | count
2 count for games | count for games
3 account with | count and something
4 counting for |
5 count and something |

Find method doesn't work because it has 2 limits , xlWhole or xlParts,
with xlWhole I cannot get A2 and A3, with xlParts I get all 5 records

Thank for help
Leo