View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ardus Petus Ardus Petus is offline
external usenet poster
 
Posts: 718
Default How can I get around "Find" if there's nothing to find

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