find next

  1. T

    Macro has hard code first cell, how to find next cell with data

    Hello, In the link below some code is hard code referring to specific cells. I thought the source was always going to be the same column, however I just ran it a few times and found a glitch. In this line of codews2.Range("A1").Value = ws1.Range("BL3").Value BL3 was always the cell or so I...
  2. A

    VBA: Find & Find next function: Return multiple value in a single cell if the ID match

    I am using find function to match ID in Report Worksheet with the ID in Data worksheet and return the data to the ID in Report Worksheet if there is a match. For unique with multiple match, the code is only returning the ID data which every is last match in the search range in Master worksheet...
  3. W

    Find next Function using 2 criteria help

    Hello All, First of all sorry if this is answered somewhere already, but I didn't know exactly how to word it. I am an Engineering Intern that has somehow been tasked with writing Excel Macro for the last month. I've taught myself quite a lot so far but cant figure this one out. The first...
  4. J

    Another Darn .FindNext Question

    Hello everybody, While not a beginner, I clearly have somethings to learn here... I have not been able to get the .FindNext function to operate within my code. It's irritating because I thought I knew what I was doing. I am attempting to update a spreadsheet on the network from my desktop...
  5. J

    Help with loop macro, find next

    Hi there, I seem to need a little help with my loop. values and rows will change. I'm looking at values in column A, if the value is the same as the value below (A2 - A3) delete A2, if it is diferent then move to the cell below. this is my code Dim rCell as Range Set Rngy = Range("A2:A" &...
  6. K

    Find text between delimiters in a cell and extract text between the following delimiters

    Hi, I've spent months trying to research a solution to my problem and after reading another post from your site that was very helpful for a different issue, I thought maybe you can help me. In A2, there are a list of headers followed by descriptions, one-after-the-other. For example, I have...
  7. L

    VBA Search Box - needs try again option

    Hi All I found some code online to run a basic value search on a column. I have modified it to suit my needs, but as I would like to add the function to "Try Again" if the returned result is not the correct one. I need this because the search is for names, and the sheet used by lots of people...
  8. B

    Creating my own search box to find a keyword and then an option to find next.

    Good morning all, I am having some problems with some code. I want to be able to search for keywords in a spread sheet with the option to find next. I understand that I can press CTRL-f but I would like to have a cell with a search box. I have done all I can to get this to work but so far...
  9. D

    Find All, Copy Adjacent Cells, Paste in New Window

    I need to separate numerous data entries by year, so I need to find all entries containing the year in question, copy the cell year is listed in as well as 2 cells on either side, and paste the 5 cells into a new spreadsheet. Here's the code I have closest to working...
  10. S

    VBA for Find Word, run macro, find next....

    <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...
  11. E

    Find Insert Multiple Occurences

    I need help with an Excel Macro. I need to find each occurence of 24 different TEXTs and next to each insert cells to add additional information. The number of occurences of each text varies and may appear in the range of K2:IV2000, so there may be for example 14 occurences of TEXT1 and then 35...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top