Determine cell with greatest value
Posted on 2012-03-30
I want my code on any worksheet_change (usedRange A1 to H20) that it determines in the Range(B1:D1) which cell has the highest numeric value.
If B1 is highest then B2.value = 50
elseif C1 is highest then C2.value = 50
elseif D1 is highest then D2.value = 50
This is the basis for what I need it to do - I have other steps to add after it determines the right cell. But this will get me started and probably finished.
Can you assist please,