selection.find

  1. R

    go to cell in column with date closest to today's date

    I am trying to create a macro that I can click on so that wherever I am in a worksheet, it will zip me over to the cell in column A that has the date closest to today's date. I set it up initially by recording a macro and searching for a date I already knew was in the column as a starter...
  2. H

    Selection.Find not finding number with scientific number

    Hi everyone, I declare a variable as variant. The input for the variable are mostly strings and some scientific numbers. The Selection.Find keeps giving errors whenever it tries to find a scientific number. I formatted the data in the search row as "general". Below you can find part of the...
  3. R

    selection.Find sometimes works sometimes not

    Hi, I've got this section of code that runs perfectly well in another sub but when I move it to a new sub I get a runtime error 91. Any help would be really appreciated. From Selection.find to .Activate highlights yellow Sheets("ADP_Times_All_Teams").Select...
  4. R

    trouble with Selection.Find

    the code below works fine until it no longer finds what I am looking for (example is AR) When it has found the last of "AR" I get an error to debug and the section from Selection.find to False).Activate is highlighted yellow. Any help would be really appreciated. Sub ARK_DEP() For i = 1 To...
  5. L

    Error Handling with Selection.Find not working fine

    I have an excel where I have to check if an account is present in which of two account listings. Else, I have to go to the next account. The code I am using is: <code style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console'...
  6. S

    VBA - find and move cells

    I would be very thankful for some help. I have a spreadsheet from a text download so data appears in different columns in different rows. For example, my "inclusions" may appear in R3, Q4, P2, etc., followed by the specific inclusions in S3, R4, Q2 and so on. I am trying to line up the cells...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top