FIND (Two questions)

[gary]

Question #1:

FIND is normally the first step of a two-step process:

1. FIND locates a cell with the specific text or numbers
contained in the "Find What" box.

2. Once a cell is found, a different action is done (i.e.,
deleting the cell, deleting the cell's contents, copying
the cell's contents, pasting different data into the cell,
etc). (FIND/REPLACE may not be appropriate for this
action). To perform this action, the FIND box must be closed.

To locate the NEXT cell with the specific text or numbers,
you have to do FIND again, close the FIND box and do the
action. And, you have to repeat this sequence for
subsequent cells with the specific text or numbers. (This
is a lot of work if you have to perform the action on a lot
of cells).

Is there a way to perform the action with the FIND box open ?

===============================

Question #2: Is there a way to do a "backwards" FIND (to
locate a PREVIOUS cell containing the specific text or
numbers).

 

[papou]

Hi gary
This would be possible using VBA since you can use the FINDNEXT and
FINDPREVIOUS methods together with the FIND method.

HTH
Cordially
Pascal

 

[Peo Sjoblom]

Look at flexfind, it is a great utility and improves the built in find a lot
It will give you a list with all hits it finds

http://www.bmsltd.ie/DLCount/DLCount.asp?file=FlexFind.zip

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[JE McGimpsey]

FWIW, in MacXL, you can close the Find box and use the keyboard shortcut
CMD-g to find the next instance, or Shift-CMD-g to find the previous
instance. For compatibility in my cross-platform apps, I usually include
a Windows-only conditional compilation that assigns a keyboard shortcut
to the FindNext method and FindPrevious methods.