Okay, should be a quick fix, but my bug eyes are tired of looking at this. I need to find a number I know is in column r:t. I have attached the first code that looks for something in column a:e and it works fine. I have tried for 4 days now to modify it to work with column r:t and looking for a number (a phone number) . Can't get it to work. Please help. What am I missing?
This one works:
This one doesn't:
the lcount variable is strictly me testing it.
Foundcell consistently finds "nothing"!?!?!?!?!?
Clearly I am missing something.
Thank you.
Bookmarks