Scope determines the extent of the search. You can choose to search the active worksheet, active workbook or all open workbooks.
AdvancedSearch searches worksheets only. It does not search Excel4 Macro sheets, dialog sheets, modules and charts.