excel find problems

C

camron107

I have a database in excel with 4 sheets.

When I want to conduct a search, it only searches the active sheet.
Therefore I have to select each sepearte sheet and carry out 4 individual
searches.

Is there any way to search all sheets at once?

If there is not, I am aware I can create a user form and use the approproate
syntax to conduct my required search. However this will take me a long time.
If there is an easier apprach then please let me know.

Regards

camron
 
J

Jerry W. Lewis

What version of excel? How are you searching? In later versions of
Excel, you can select multiple sheets and have Edit|Find apply to all
selected sheets.

Jerry
 
R

Ron de Bruin

Hi

Try this

Right-Click one of the sheets and click "Select All Sheets" on the shortcut menu, then perform your search.

If any one of your sheets has more than one cell selected, this method won't
work correctly. After selecting all sheets, press Ctrl+A to select all
cells on all sheets to force the Find to search them all.

If you are using XL97, the "select all sheets" method will not work. You can
"Replace" across sheets, but not "Find".(Gord Dibben)

In Excel 2002-2003 , there is a "Within:" option in the Find/Replace dialog with a Workbook option.

You may want to try Jan Karel Pieterse's FlexFind at:
http://www.bmsltd.co.uk/MVP/Default.htm
 
C

camron107

it is excel 2000 and I do not think it supports this feature...

I have another question also...

I am tryin to get the workbook event procedure

Sub workbook_beforeclose()
Sheets("Organisations A-F").Select
Call sort_column
Sheets("Organisations G-L").Select
Call sort_column
Sheets("Organisations M-R").Select
Call sort_column
Sheets("Organisations S-Z").Select
Call sort_column
ActiveWorkbook.Save

End Sub


to work, but it comes up with a compile error:

"Procedure declaration does not match description of event or procedure
having the same name

What is that cause of this??

Thank you for your help
 
Top