Correct find syntax
 

Hi, ive used find a lot in the past in the following wa
cells.find("WHat i want")
I'm not sure how to use the after part of the clause? Ive bee tryin
following with no joy, can someone shed some light as its not covere
in help file

cells.find("receipts", after:=C5)
cells.find("receipts",after:="C5")
cells.find("receipts",C5)

My code breaks for of these and i really don't want to start the fin
in the top left corne

--
cereldin
-----------------------------------------------------------------------
cereldine's Profile: http://www.excelforum.com/member.php...fo&userid=3206
View this thread: http://www.excelforum.com/showthread.php?threadid=55850

Correct find syntax
 

cells.find("recepits", after:=range("C5")).select

will make the first instance of "receipts" after cell C5 active - bu
if it's not found below/right of C5 it wraps back and begins searchin
at the top... if you really don't want to search the first few rows
change "cells" to a reference to the range you're trying to search.

(I take it "receipts" really does appear on your sheet? If it doesn'
your macro will break anyway...)

Co

--
colofnatur
-----------------------------------------------------------------------
colofnature's Profile: http://www.excelforum.com/member.php...fo&userid=3435
View this thread: http://www.excelforum.com/showthread.php?threadid=55850