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