Find row number

[GLENEE]

I have a unique value on an Excel form. How can i use that value to look up the row number on another worksheet where that value is also stored. Thanks

 

[xlbo]

the MATCH function should do just fine for you

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[GLENEE]

Thanks not used that before. Returns the correct information, just got to work out how i use it in VBA?

 

[xlbo]

dim theRow as long

theRow = application.match(....



Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[SkipVought]

Post VBA questions in Forum707.

Skip,
[sub]
Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty![/sub]