Vba - Contractor UK Bulletin Board

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!

You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:

You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

Zorba replied

12 July 2007, 15:48
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.
Leave a comment:
Xenophon replied

12 July 2007, 15:44
Originally posted by kramer

whatever
Leave a comment:
kramer replied

12 July 2007, 15:42
whatever
Leave a comment:
TheRightStuff replied

12 July 2007, 15:39
This in-built function should do it:

docmd.FindRowNumberGivenMaximumTopValue.bothered
Leave a comment:
MrRobin replied

12 July 2007, 15:21
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
Leave a comment:
kramer replied

12 July 2007, 15:19
todays sub of the day is

Italian BMT
Leave a comment:
Kyajae replied

12 July 2007, 15:12
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?
Leave a comment:
Zorba replied

12 July 2007, 15:08
what was today's sub of the day? I'm sick of sweet chilli chicken.
Leave a comment:
kramer started a topic Vba

12 July 2007, 15:07
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?
Tags: None

Working...

X