Thanks Jim. That somewhat makes sense. Just a couple other questions...
Why can I still use if FindCell = ""? Do I just use "is" with the
"nothing" command?

Die_Another_Day

Jim Thomlinson wrote:
Is referes to objects. = refers to variables. So for a range object or a
worksheet object you need is. For an Integer or a String you want =...
--
HTH...

Jim Thomlinson


"Die_Another_Day" wrote:

Hi Ardus, quick question. What's the difference between "is" and "="? I
mix those up frequently and am not sure when it's appropriate to use
them.

Tx

Die_Another_Day

Ardus Petus wrote:
Typo!
If FindCell is Nothing

Et voilà!

Cheers,
--
AP

"CarolineHedges"
<CarolineHedges.2a0kgp_1151332807.9415@excelforu m-nospam.com a écrit dans
le message de news:
...

I have input the code, but it doesn't like the bit:

If FindCell = Nothing Then

An error message comes up as "Invalid use of object".

It wont even run the macro with this part.... help!!


--
CarolineHedges
------------------------------------------------------------------------
CarolineHedges's Profile:
http://www.excelforum.com/member.php...o&userid=35705
View this thread: http://www.excelforum.com/showthread...hreadid=555574