"No more instances found"

In a macro I have this search procedure (bottom up and right to left)

Please Login or Register  to view this content.

Silly, but I don't know the proper code saying "if there are no more occurrences, then...". None of those in the HELP section (Not Found, NoMatch, Is Not) seem to apply.

Thanks for your patience
ACA

2 ways
1)

Please Login or Register  to view this content.

2) use object variable

Please Login or Register  to view this content.

Thank so very much to you both, jindon and royUK, for the immediate help.
aca

Your code, works O.K., but finding one or all occurrences at once, and then stopping, is not what I need;
sorry I didn’t express myself well.

First, in each case I enter, through an input box, the chain I'm looking for (which I call ‘c’)

Please Login or Register  to view this content.

But then I need for the macro to do just what a general search function does (only upwards) i.e.
Go up, PAUSE at each occurrence and, if that cell is the one I need, let me exit the search and have the cell copied etc.;
if it is not, let me click somewhere else and GO ON TO THE NEXT occurrence and pause again. And so on.
But when there are no more, let me kow also (message box “No more to be found”).

Thanks for your help, and sorry I first mistakenly posted this as a new thread.
ACA

Please Login or Register  to view this content.

Thank you, jindon: works great! It's what I needed
Bless you.
ACA