• Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
  • Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Vba

Collapse
X
  •  
  • Filter
  • Time
  • Show
Clear All
new posts

    Vba

    Excel + VBA + Headache + Rain + sub of the day = a total pain in the A$$!

    How do i find a row number given a maximum top value?
    --------------------------------------------------------------------------------

    SA - Is it like a dragons nostril?

    #2
    what was today's sub of the day? I'm sick of sweet chilli chicken.

    Comment


      #3
      Originally posted by kramer
      Excel + VBA + Headache + Rain + sub of the day = a total pain in the A$$!

      How do i find a row number given a maximum top value?
      Use HLOOKUP?

      Comment


        #4
        todays sub of the day is


        Italian BMT
        --------------------------------------------------------------------------------

        SA - Is it like a dragons nostril?

        Comment


          #5
          Originally posted by kramer
          Excel + VBA + Headache + Rain + sub of the day = a total pain in the A$$!

          How do i find a row number given a maximum top value?
          counter = [start row number]
          While cells(counter, 1).value < topvalue
          counter = counter + 1
          Wend

          msgbox counter
          It's about time I changed this sig...

          Comment


            #6
            This in-built function should do it:

            docmd.FindRowNumberGivenMaximumTopValue.bothered

            Comment


              #7
              whatever
              --------------------------------------------------------------------------------

              SA - Is it like a dragons nostril?

              Comment


                #8
                Originally posted by kramer
                whatever
                Rule #76: No excuses. Play like a champion.

                Comment


                  #9
                  Originally posted by kramer
                  todays sub of the day is


                  Italian BMT
                  My word... I love those. Now all I need to do is casually find out what Mrs Zorba has planned for tea and see if it's worth getting one of these instead... mmmm.

                  Comment

                  Working...
                  X