XL98: FindPrevious Method Does Not Support Nonadjacent Cells

ID: Q184095

The information in this article applies to:

Microsoft Excel 98 Macintosh Edition

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:

   ARTICLE-ID: Q179216
   TITLE     : OFF98: How to Use the Microsoft Office Installer Program

Additional query words: find next non-adjacent nonadjacent XL98 discontiguous

Keywords          : kbprg kbdta xlvbahowto xlvbainfo OffVBA 
Version           : MACINTOSH:98
Platform          : MACINTOSH
Issue type        : kbbug
Solution Type     : kbnofix

Last Reviewed: April 18, 1998