Thanks for trying, Rick.

Mike helped me out.

Walt

"Rick Rothstein (MVP - VB)" wrote:

I have created a saving comparison spreadsheet. I have 5 vendors bidding to
provide replacement OEM parts at a reduced price. Now I need to select the
vendor (cell) which has the greatest savings (value).

So, I want to look at 10 cells in a row and select the cell which has the
greatest value number.

I'm not sure I understand your layout... you have 5 vendors but want to look
at 10 cells in a row?

Rick