rngfind

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

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

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

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

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

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