Hi all,

If I have more than one occurrence of a word (say "Ford") in Col A (say A1, A5, A10, and A14) and I want (with VBA) to return the number of occurrences and the first and last cell addresses (ie 4 times and "A1" and "A14") can anyone point me in the right direction please?

Regards

Seamus