I'm fairly new with this....

Could you explain what the code is saying, and also, I want it to
search the whole sheet and not just one column.
Jim Thomlinson wrote:
You can use find something like this

dim rngFound as range

set rngfound = sheets("sheet1").Columns("A").Find(What:="Find This", _

LookIn:=xlFormulas, _

LookAt:=xlPart, _

MatchCase:=False)
if rngfound is nothing then
msgbox "Sorry... Not found"
else
rngfound.select
end if
--
HTH...

Jim Thomlinson


" wrote:

Ok...
I'm writing a macro in which i know that none of the values created in
a worksheet will be the same (except for blank cells). What
code/command can I use to search for a specific value in the worksheet
and then select the cell that contains that value?

Thanks in advance.