Searching a complete work book

[itsfisko]

Hi All is it possible to search every page in a work book by using the find?

Some lead, some follow....I just Hope!

 

[xlbo]

If you have XP then it's an option when you use Ctrl+F (Find) - one of the dropdowns allows you to choose between worksheet and workbook. If not then it's code I'm afraid

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[itsfisko]

the drop down only searches active sheet

Some lead, some follow....I just Hope!

 

[xlbo]

which dropdown ? As I said - if you have XP, then the 1st dropdown (Within allows you to search the workbook. If you don't have this option, the only way to do it is via code

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[RogADog]

You can do it in Excel97 without having to resort to code. Select all sheets in the workbook and then do your find.

Cheers

Rog

 

[xlbo]

can't comment on '97 but in XP, it'll only find the cell using that method if the sheet that contains the search item is the active sheet in the group of sheets

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[GlennUK]

Hi Geoff,

that method works in Excel 2000, so I wonder why it doesn't do it XP! M1cros8ft developing products with less functionality than previous versions??? Never.


Glenn.

 

[itsfisko]

more money more code less function micky soft

Some lead, some follow....I just Hope!

 

[xlbo]

Glenn - that'll be because it's a standard feature in the Find functionality of XP. To be fair, it sounds like they've listened and added it to official functionality rather than keeping it as a workaround.....

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[GlennUK]

Yes Geoff,

probably true. Might be a bit annoying for people who still expect the workarounds to work.

Glenn.

 

[xlbo]

Yeah - also, in code, there is no difference - there's no extra option for searching the workbook - if you record finding something with the Within:Workbook selected, all you get is
Sheets(x).activate
cells.find etc etc etc

which won't work when you play it back as you don't know which sheet the data is on beforehand.

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244