Visual Basic Macro Sorting help

I am trying to search through a row of a table and find the biggest value. Then I need to return that value but also the column that it is in. Here is my code so far.

Please Login or Register  to view this content.

I am mostly not sure if I am calling cells right from excel using the concatenation. I have to do this over several rows and would be up for better options if available. Thanks

Perhaps you can find something of use in this code?

Please Login or Register  to view this content.

Instead of

Please Login or Register  to view this content.

for searching all values in active sheet you could instead use

Please Login or Register  to view this content.

to search column A, B and C or you could define a specific range to search.

Alf