find and replace
 

How do you change the 'find within' option in Find/Replace macro?

If you have selected 'within workbook' but want only search a selected set
of cells in a macro.

find and replace
 

dim ran as range
set ran = Activesheet.range("A1:A10").find(what:="SearchData ",Lookat:=xlwhole)
if not ran is nothing then
'data found
else
'data not found
end if

you can change range to what ever range you need


--
When you lose your mind, you free your life.
Ever Notice how we use '' for comments in our posts even if they aren''t
expected to go into the code?


"CVL" wrote:

How do you change the 'find within' option in Find/Replace macro?

If you have selected 'within workbook' but want only search a selected set
of cells in a macro.