Select cell by value
Using the Recorder to find 15:
Sub Macro1()
Cells.Find(What:="15", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:=False _
, SearchFormat:=False).Activate
End Sub
--
Gary's Student
" 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.
|