Excel VBA to rename Column headers with same name/Value

Hi mchilapur,

See if this code works for you in the attached.

Please Login or Register  to view this content.

@MarvinP ..Yes...You are almost there..
One small concern, it is possible to start the count from '1'..? Currently it starts from '2'..

Hi,

Try this

Please Login or Register  to view this content.

The code above will put a 1 on all, even if there are no duplicates in the list. I didn't think you wanted that.

OK mchilapur,

Try this code where it will not put a number after the name if it is unique. It will put the numbers 1 after a name that has a duplicate in row 1.

Please Login or Register  to view this content.

I now think this is what you are looking for. You can pay me for my effort by clicking on the "Add Reputation" under this post.

Hi mchilapur,

Thanks for the kind words. I'm glad my third attempt finally solved your question. If you click on the "Add Reputation" star it simply gives me some assurance that my free work is appreciated. It costs you nothing but reassures me that my free help is worth a "thank you". Again, thanks for suggesting I have some knowledge of Excel.

Thanks again.