Find column with max value
Posted on 2012-03-31
I need to start to my code from the Sheet.activate. I need to do this in vb since I have other code to add later, I want to avoid setting this up in the Excel sheet.
I need to find the column with the highest max value from range ("AG4:AK4") and then have have column +1.value to equal 50.
If you could guide me along with the next step too - it would be very helpful. The next step would be if AG5 = 50 then 'do this, if AH5 = 50 then 'do this etc etc.
I have tried numerous things but keep getting errors from object not set to other issues. I have given up and have turned to you guys.