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?
How do i find a row number given a maximum top value?
-
--------------------------------------------------------------------------------
SA - Is it like a dragons nostril? -
what was today's sub of the day? I'm sick of sweet chilli chicken. -
Use HLOOKUP?Originally posted by kramerComment
-
todays sub of the day is
Italian BMT--------------------------------------------------------------------------------
SA - Is it like a dragons nostril?Comment
-
counter = [start row number]Originally posted by kramer
While cells(counter, 1).value < topvalue
counter = counter + 1
Wend
msgbox counterIt's about time I changed this sig...Comment
-
This in-built function should do it:
docmd.FindRowNumberGivenMaximumTopValue.botheredComment
-
whatever--------------------------------------------------------------------------------
SA - Is it like a dragons nostril?Comment
-
Originally posted by kramer
Rule #76: No excuses. Play like a champion.Comment
-
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.Originally posted by kramerComment
Comment