Vba for row number of evaluate and max

**stevow** · 04-20-2010, 07:43 AM

Hi all

Scratched my head with this one most of yesterday before giving up and now seeking your advice!!

The result of my code needs to select the row of a result using the below vba. The below will currently display the cells value.

Please Login or Register  to view this content.

Any help greatly appreciated!!!

**DonkeyOte** · 04-20-2010, 08:15 AM

Change the formula to return the ROW value

Please Login or Register  to view this content.

Not clear what you want to do with the resulting value... eg

Please Login or Register  to view this content.

**Andy Pope** · 04-20-2010, 08:18 AM

One way, which will return first occurance.

Please Login or Register  to view this content.

DO, doesn't that formula return the first row with a value over 20 rather than the row with the lowest value over 20?

**stevow** · 04-20-2010, 08:20 AM

Hi Donkey

I tried this one, it returns Run-TIme error 13

Any ideas?

Thanks

**Andy Pope** · 04-20-2010, 08:22 AM

RTE-13 is due to missing bracket.

Please Login or Register  to view this content.

**DonkeyOte** · 04-20-2010, 08:24 AM

Originally Posted by AP

DO, doesn't that formula return the first row with a value over 20 rather than the row with the lowest value over 20?

Andy, yes you're quite correct - oversight on my part - stevow please disregard in favour of Andy's MATCH.

**stevow** · 04-20-2010, 08:59 AM

Great stuff - thanks to you both for the input!! My head can now grow hair again!!

Vba for row number of evaluate and max

LinkBack

Thread Tools

Rate This Thread

Display

Vba for row number of evaluate and max

Re: Vba for row number of evaluate and max

Re: Vba for row number of evaluate and max

Re: Vba for row number of evaluate and max

Re: Vba for row number of evaluate and max

Re: Vba for row number of evaluate and max

Re: Vba for row number of evaluate and max

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions