Hi,

I have a data table which represent score value in Range("A1:E10")

can anyone help me to write vba code to determine the highest and lowest score value?