XL98: FindPrevious Method Does Not Support Nonadjacent Cells (184095)


The information in this article applies to:

  • Microsoft Excel 98 Macintosh Edition
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

Modification Type:MajorLast Reviewed:9/11/2002
Keywords:kbbug kbProgramming KB184095
©2002 Microsoft Corporation. All rights reserved.