I am trying to create a macro from scratch that can tell me what value is the
maximum value in a column of values and then what the value is in the cell to
the left of that max value. I thought a for loop would work for the max
value part but i dont know how to get it to do that last part. Any help
would be great, I am not good at programming.