rngfind

  1. kelly mort

    Having trouble with how to format search criteria to match dates in a column- vba

    My dates are found in column B and in the format “dd-mm-yy” – this is how they look to my eyes but when I click on them, they look like “dd-mm-yyyy” in the formula bar. When I then do my search for the date with the inputbox entry, it throws back to me the message alert that the said date from...
  2. M

    VBA - add comment to cell that script highlights

    I have a code that highlights the cell if the cell value matches the array and it is working perfectly. I was wanting it to also add a comment to the cell it locates from the array and after much searching for this I am unable to get it to add the comment correctly to the cell it found from...
  3. R

    Makro for finding dates and copy/paste content from below

    Hi I have this code which basically finds the date I need from a table and copies a certain number of cells below and pastes it somewhere else. My question is how I could amend it so that after the first round a question box appears which asks if more dates are needed. If yes again it should be...
  4. kelly mort

    Show alert when lookup finds more than 10 rows

    Hi I have this lookup code and I need a little adjustments to do my bidding. I want to avoid loading the listbox when the data exceeds 10 rows. I have been starring at it for a while. I can't figure out what to place and where to place it. Sub Lookup() Me.lstView.ColumnCount = 6...
  5. S

    Search Text and Error Handling

    Hi, I would like to search a text in my spreadsheet and delete the row partially. If it doesn't find the text, I would like it to move on with the rest of the code. I keep getting the mismatch error here. ' Delete FV ONLY Row Set rngfind = Cells.Find(What:="FV ONLY", After:=ActiveCell...
  6. T

    Strange behaviour using Range().Find and column width

    If I run the code below it works fine. First test1 and then test2. As long as the width of the columns show the whole number in the cells!! But if I make column A as narrow as the number change to ## and hide column B, test2 will not find the first and the second number?! (I found a workaround...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top