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

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top