Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

need urgent help regrading a macro

sanju_techiesanju_techie Posts: 1Member
Hi , I m very novice to macros , I need a very needed help to construct a macro , actually i have a set of rows which contains few columns that have different numbers , I want to have a macro that would compare or check all the columns contain numbers and select the highest maximum value from the row and then it will compare the selected value with some number i.e if the selected highest number is 3 then it will check if 3 not greater than 5 , then it will simply put 5 in a blank cell within that row. And the macro would repeat the same for each row till the last.

I m trying to give you a visualization of the actual scenario:

Col A Col B Col C New Column
row 1: 4 1 7 if Col C(Max value) <=8 8 will be insert in this col
row 2: 5 8 10
row 3: 98 49 56

now the macro would start from row 1 compare Col A ,Col B, Col C and get the Highest value (e.g 7 for row 1) then it will check if value of Col C <= 8(this value will be in the macro itself) then it will simply put 8 in the Column new.The same will be repeated till the last row .

It will be highly appreciated if anyone can give me a macro doing the things i have mentioned for me. Thanx in advance
Sign In or Register to comment.