find and replace

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to do a simple clean of one column by copying and pasting(finding and replacing) phrases in adj 4
Find and Replace 1
Find and Replace Within a Range Versus Workbook - Suggestion 2
processing time (revised and re-posted) 10
Find and Replace in VBA 3
VBA set thick borders around non empty cells in range 0
Find and Replace within workbook - from Visual basic 2
MS word Find and Replace using Regex - Help required 0

Back
Top