FIND (Two questions)

G

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).
 
P

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
 
J

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.
 
Top