Vba

[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?

 

[Zorba]

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

 

[Kyajae]

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?

 

[kramer]

todays sub of the day is


Italian BMT

 

[MrRobin]

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

 

[TheRightStuff]

This in-built function should do it:

docmd.FindRowNumberGivenMaximumTopValue.bothered

 

[kramer]

whatever

 

[Xenophon]

whatever

 

[Zorba]

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.