VBA lesson 6 - FIND function - ExcelVBASql.com 25+ hours of FREE training!

[DominiqueDolly]

How do you highlight the cells that contain the value found?

[ReubenSnjente]

Set result = .Find(What:=searchterm, After:=.Cells(1, 1), LookIn:=xlFormulas, LookAt:=xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:=MatchCase)

[docjackson33]

Can you elaborate more on not replacing the value in the cell. I tried "result.address Not last result" but I'm not sure of what to right anyway. Thanks for your help and for sharing this info.

[mray1974]

This is really what i was looking for but can you help me on how to find any words in word document from excel. Example: A command button in Excel sheet will open a word file and then search for the word i'm looking for and will bold or color the selected word.

[lindejos]

If I use .Cells(.Cells.Count) in the After setting the code bugs out with an overflow error, but If you change it to the (1, 1) cell it works fine.

So change the setting After:=.Cells(.Cells.Count) to After:=.Cells(1, 1)

[andoski99]

I keep getting an overflow error - number 6 with this code... not sure what the issue is as I have copied your code directly I think.

[obesechicken13]

Can you upload your code in a text file? I seem to be having problems. Thanks.