Microsoft KB Archive/184095

= XL98: FindPrevious Method Does Not Support Nonadjacent Cells =

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.

