Find Large VBA

[mahmed1]

Hello

i have some month names across A:E
January (merged a1:b1) February (c1:d1) etc

now i need a code that will look in b:d:f etc row 2 to 100 and see which is the largest value found and then give the month of the largest value found and if there is a tie then give me that month also

this should be displayed in a msgbox with the value

If i had 60 as the largest value found for feb and may then
msgbox (Largest amount (value) to be given in feb and may)

 

[mahmed1]

With the above i meant the expected Function dont give the result i wanted. I am after the next due date and not last due date. All the other codes work fine. If there are no expected amounts due then display blank or no income due