I did a more testing. It's always nothing! If it finds the text, the
range variable is nothing. If it doesn't find the text, the range
variable is nothing.
That begs the question: If you do a "Find" in a macro, how do you know
if a cell with that value was found? I copied a "If Not rangevariable
is Nothing" from another thread which I thought would tell me if the
value had been found. I guess it does something else. So, after you do
a find, how do you know if it was found or not?
Thanks!