VBA Find() question

**VBA Noob** · 04-20-2009, 01:29 PM

Moved to programming....

Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.

VBA Noob

**dorkydude666** · 04-20-2009, 01:40 PM

Sorry about putting it in the wrong forum.

rFound is not changed with my code. Now that I think about it though, do you think that .Activate at the end is changing what rFound is supposed to be?

Consider the differences between:

Set rFound = Cells.Find(What:="(", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
        xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
        , SearchFormat:=False).Activate

and

Set rFound = Cells.Find(What:="(", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
        xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
        , SearchFormat:=False)
rFound.Activate