Article ID: 189629 - View products that this article applies to.
This article was previously published under Q189629
When you use the Find dialog box to locate specific information, Microsoft Excel for Mac only finds occurrences of the value on the active worksheet (even if you have selected multiple worksheets that contain this information).
If the information is not on the active worksheet, but is located on another sheet in the group, Excel for Mac may find the occurrence on the last sheet in the group with that value; however, it will not search any grouped sheets in between.
NOTE: This is not a problem when you use the Replace command. Only the Find command exhibits this problem.
This problem occurs because the Find command does not work across grouped worksheets. Excel for Mac Help states that if a group of sheets is selected, the Find command searches all of the sheets in the group except Visual Basic modules. This is not the actual behavior. When you select multiple worksheets, and you use the Find command to search for information on a worksheet, only the first occurrence of the value is found.
Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements. To work around this problem, you can use a Microsoft Visual Basic for Applications macro (Sub procedure) to search each worksheet that is selected in group mode. To create the macro, follow these steps:
For more information about the Find command, click Microsoft Excel for Mac Help on the Help menu, type find or replace data in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Article ID: 189629 - Last Review: October 6, 2011 - Revision: 4.0
Contact us for more help