Results 1 to 17 of 17

Locate Numbers 26 and higher

Threaded View

  1. #9
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,694

    Re: Locate Numbers 26 and higher

    Which part of the supplied suggestion are you referring to?
    Have you tried the code? It is "hard coded"

    An explanation might help.
     'The three ranges that need checking
    a = Array("D3:D12", "F3:F12", "H3:H12")
    
     'The row number where the first cell address will be pasted into
    j = 3
    
     'Loop through the previously mentioned ranges, from the first to the last
        For i = LBound(a) To UBound(a)
    
     ' Loop through each cell in the range that is being checked
            For Each c In Range(a(i))
    
     ' If there is something in that cell
                If Not IsEmpty(c) Then
    
     'Split the value into parts separated at the hyphen = - sign and use the 2nd part for comparison
                    If Split(c, "-")(1) > 25 Then
    
     'Put the address of that cell in cell B3 if the value is > 25 and increase the row number by 1 for the next time it finds what it is looking for
                        Cells(j, 2) = c.Address(0, 0): j = j + 1
    
                    End If
                End If
    
     ' go to the next cell for comparing values
            Next c
    
     'go to the next range to check
        Next i
    Last edited by jolivanes; 07-04-2019 at 11:44 AM. Reason: explanation

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Random Numbers Attempts Must Be Higher Than Made
    By xjohnson in forum Excel General
    Replies: 3
    Last Post: 12-10-2018, 02:00 PM
  2. Replies: 7
    Last Post: 03-23-2018, 08:27 PM
  3. possible to locate higher hierarchical list of HTML code?
    By lubbamkt in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-03-2014, 09:27 AM
  4. [SOLVED] The user cannot type in numbers higher than 20. How to prevent him from doing that?
    By Shishek in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-04-2013, 09:48 AM
  5. [SOLVED] Look at Range of numbers and return the next number higher than x
    By gonhikin in forum Excel General
    Replies: 3
    Last Post: 12-07-2012, 12:07 PM
  6. Locate two equal numbers in an array of numbers
    By avveerkar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-05-2010, 01:22 AM
  7. [SOLVED] Can I flag numbers that are higher/lower than a range of #'s
    By Rick Parker in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-07-2006, 09:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1