Article ID: 184095
Article Last Modified on 9/11/2002
APPLIES TO
- Microsoft Excel 98 for Macintosh
This article was previously published under Q184095
SYMPTOMS
When you use the FindPrevious method, the incorrect address is returned if
you use this method with a range of nonadjacent cells.
CAUSE
The algorithm that is used by the FindPrevious method enumerates (counts or
searches) the cell references in a forward direction while the cells
themselves are enumerated in reverse order.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
MORE INFORMATION
The FindPrevious method continues a search started with the Find method. It
finds the previous cell that matches the same conditions and returns a
range object that represents that cell. The FindPrevious method does not
affect the current selection or the active cell.
REFERENCES
For more information about the FindPrevious Method, click the Office
Assistant inside the Visual Basic Editor, type
FindPrevious, click
Search, and then click to view "FindPrevious Method."
NOTE: If the Assistant is hidden, click the Office Assistant button on the
Standard toolbar. If Microsoft Help is not installed on your computer,
please see the following article in the Microsoft Knowledge Base:
179216 OFF98: How to Use the Microsoft Office Installer Program
Additional query words: find next non-adjacent nonadjacent XL98 discontiguous
Keywords: kbbug kbnofix kbprogramming KB184095