I have a workbook with 5 sheets in. When I recorded a macro using Find all
worked well. But when I come to run the macro I get a run time error 91. This
is the Macro,
Sheets("ft mid - small cap").Select
Cells.Find(What:="al_", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:=
_
False, SearchFormat:=False).Activate
I think that when the worksheet named is active it works fine, but I would like
to search the whole workbook, as later the What will change. I recall trying to
do this before and seem to remember using the 'with statement'. Please can
anybody advise.
Regards Robert