.find

  1. A

    .Find Type Mismatch Issue

    Aloha all! I've ran into a Type Mismatch Error when trying to 'set the last row' of a sheet. What I've done was create a separate public function that the original code should use. However, when it goes to the public function, the error arises. What I was hoping was the public function would...
  2. M

    Issue with Find in my script

    This works fine, but I rather not use .Select Range("F13:F22").Select For Each c In Range("F25:F33").Cells If Not IsEmpty(c.Value) Then Set FoundCell = Selection.Find(What:=c.Value, LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False) If...
  3. C

    Insert "X" every certain number of columns after finding "X", based on value of cell in same row

    Hello all, I am trying to write VBA to do a specific task, and I am almost there. I simply need a little bit of help to figure out how to do the remaining actions. Here is what I am trying to do with this code: 1) For rows 11 to 185, search range L11:DK185 for the cell value "X" 2) If "X" is...
  4. J

    How can you find multiple match in a cell and select the one with the latest date attribute to it

    Hello my fellow excel-ers, I am trying to find search through a range of cells in column A from my excel spreadsheet. I know that I can use .Find to find the first match in that range or use .FindNext to find all of them. But my issue is I would like to find the match for my latest...
  5. J

    Select most recent occurrences using cells.Find

    Hi, I have this data: UserID Date 1 03.22.2019 1 03.22.2018 2 03.22.2019 3 05.22.2018 3 05.22.2019 I would like to go through it using and select the user with the most recent...
  6. W

    Search Userform but not on the active sheet

    Good Morning All, I am new to the world of userform's and think they are pretty dam amazing. I am currently struggling with a small piece of code and was wondering if somebody could guide me. I have a userform where users need to input results for an employee. The user inputs the employee ID...
  7. D

    vbscript .find ignore spaces

    I have a script that searches phone numbers Set rngFind = .Find(What:=Trim(txtLookup.Text), LookIn:=xlValues, LookAt:=xlPart) Some of the numbers have spaces and some are just numbers. eg in the database a phone number may show up as "0218888888" or "021 888 888" Is there a way so when my...
  8. P

    wildcard use in range .find

    I am running a macro against 20 workbooks. It appears that there is no consistency in how thay are created. I am trying to copy a few cells from one of the sheets. I am using the .find method to locate the beginning of the data to copy. I thought I was going to be able to do...
  9. M

    Identifying unique data based on 2 criteria using the .find function

    Hi all, I am working on a macro that will take data from one workbook and move it into another scheduling workbook. When i transfer the data over to the scheduling workbook I need to check to make sure the data i am transferring is unique based upon two criteria, Job# and heat#. If the new data...
  10. A

    Need to make the .find loop more efficient

    Hello everyone, I've put together a code for below steps. However, I feel the procedure is too basic and there might be more efficient ways of doing the same. The present code is taking quite long, particularly the .find loop. I would really appreciate any help you can provide. Procedure...
  11. L

    VBA Run Time Error .Find

    Hi All, I'm very new to VBA and try to resolve most of my problems through looking at everyone's helpful posts! however, this time I can't seem to figure it out. I am trying to find "TS" in a specific column and filter for those rows if available. If not available, I just want to exit the sub...
  12. C

    union , multiselection with .Find method and static range

    Hi everyone! I'm struggling with the following code which you can see below. It is totally a pain in the *** now. I really need some help. This code is a search tool which looks for criteria from every worksheet except the summary and the list. After the .Find founds the word, then the code...
  13. E

    .Find Not Working After Adding New Pivot Table Code

    Hi all, I'm hoping someone can point out what I'm missing. My macro was working fine until I tweaked it, by adding code to create 2 pivot tables. Now, when it returns to the previous code that finds and highlights a specific Subtotal row, it can't find it. If I remove the new code, the macro...
  14. P

    Using .Find to locate a row that meets multiple criteria

    Hi I've always referred to these forums but I was unable to find the direct answer to my question this time so I figured it was time to create an account. The basic idea of what I want to do is to use tag based logic to find the category that meets my specified criteria. At First I was just...
  15. D

    .Find Issues

    Why do these return the same sum value? I thought .find was for total cell value and Cell Like "*5*" finds any cell with a 5 in it. Set Psize = .Range(Header.Find("0.5" & ChrW(956)).Offset(rowi, 0), Cells(Header.Find("0.5" & ChrW(956)).Offset(rowi, 0).Row, LastColumn)) Cells(Header.Find("0.5" &...
  16. T

    [VBA] Finding the cell based on row and column values

    Hi Guys, I am currently working on tool for my team that would enable them to add events to their projects, based on date. Currently I have a following s/s: <tbody> A B C D E F G H I 1 Project Calendar 2014-12-15 2014-12-16 2014-12-17 2014-12-18 2014-12-19 2014-12-20 2014-12-21 2014-12-22...
  17. C

    Getting information from merged cells

    Hello, I am trying to get the values from merged cells (which are at the offset of a .find gcell result) through a loop that goes through rows one by one (and looks for specific values on an other sheet) .This code goes if the cell we are looking for is merged and does the following...
  18. C

    Trouble using .Find over multiple sheets with a loop

    Hello, I am developing a code to search in an external workbook a determinated value, the fact is that external workbook has many sheets and we are having trouble making the code to search in each sheet. Here I leave you the part of the code that, without the red part, works when we look in a...
  19. J

    Simple VBA Help Needed - Search for a Value and Delete Row

    Hi - I created the following code to find the word "result" on a worksheet and if found, delete the row. The code below works but displays an error after it runs: Object Variable or With block variable not set The error relates to the code highlighted in blue below: Sub FindResult() Dim i As...
  20. I

    Find and delete header columns without a certain word.

    Hi, I need to: 1. Find a column containing the word 'target' in header. (from the range P1 to QI1 ) 2. Delete all other column without 'target' in its header. Sub Cleanup() Dim rng As Range With ActiveSheet.Range("P1:QI1") Set rng =...

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Macro to copy values across rows and transposing them and add the user id
    [FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=Calibri][SIZE=3][COLOR=#000000]Hi,[/COLOR][/SIZE][/FONT] [FONT=Times New...
Top