If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
FIND (Two questions)
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). |
#2
|
|||
|
|||
FIND (Two questions)
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 "gary" a écrit dans le message de ... 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). |
#3
|
|||
|
|||
FIND (Two questions)
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...e=FlexFind.zip -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "gary" wrote in message ... 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). |
#4
|
|||
|
|||
FIND (Two questions)
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. In article , "gary" wrote: 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). |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to find the last occurence of a character | Mike | Worksheet Functions | 4 | June 23rd, 2004 05:45 PM |
Outlook Find Stops Working | MrRadish | General Discussion | 1 | June 16th, 2004 09:55 AM |
FAQ - Frequently Asked Questions - unofficial - please read before posting - May | Charles Kenyon | New Users | 6 | May 24th, 2004 05:55 PM |
FAQ - Frequently Asked Questions - unofficial - please read before posting - April | Charles Kenyon | New Users | 0 | April 26th, 2004 03:34 PM |
FAQ - Frequently Asked Questions - unofficial - please read before posting - April | Charles Kenyon | Page Layout | 0 | April 26th, 2004 03:34 PM |