[RESOLVED] Error in FindCells

[Static]

using this:

xls.Cells.Find(What:=SEARCH_STRING, After:=xls.ActiveCell, LookIn:= _
xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
xlNext, MatchCase:=False).Activate

You get an error if it cand find it.. how do I trap for this? should I just use a regular error trap? or is there a better way....

Thanks

[Static]

another problem...

When searching.. Excel repeats the "find" if its there! how do I determine that I have looped through all the "finds"??

(Basically I am creating a function that will warn of problems if you change the sheet name... I want to check all sheets to see if that sheet name is referenced in formulas)

[dannymking]

(Basically I am creating a function that will warn of problems if you change the sheet name... I want to check all sheets to see if that sheet name is referenced in formulas)

How are you changing the sheet names? Unless this is linked files there should be no problem changing the sheet name in functions??

BTW.. Wish you wouldn't use square brackets in your name... messes the quote up..

[Static]

External app.. (In VB)
if I change the sheet name? will it fix all the "links?" (wait.. I'll try it! lol)

[Static]

youre right! didnt think it would work if I did it from an external app..

Great!