Remove repeat headers with the help of VBA code

Super Contributor

Hello Everyone, 


I have tried the VBA code and it works, but i click RUN button multiple times.

like - 

Annotation 2022-07-07 145613.pngAnnotation 2022-07-07 145633.png


So, how to normalize this with the help of VBA code?


Please help.


Here is a attached file.

2 Replies
best response confirmed by Excel (Super Contributor)


We had already resolved this in earlier discussions, Zan. See Add with the help of VBA code. 

Thank you for the response sir