Hello,
I m working on VBA code to delete columns if they have same headers. I have found some solution but most of them takes too much time as they read cells 1 by 1.
Here are some information :
- My headers are in row 1
- I need an efficient vba code that can handle 10 000+ columns in fastest way( maybe work with a variable that contains the range and than paste it back on the sheet)
- I want to keep the first instance of each column ( for example if we have headers like = " pizza - pizza - burger" I want to keep "pizza - burger" columns)
- I cannot provide an exemple but if more informations are needed I can answer you
Thanks a lot for your help
I m working on VBA code to delete columns if they have same headers. I have found some solution but most of them takes too much time as they read cells 1 by 1.
Here are some information :
- My headers are in row 1
- I need an efficient vba code that can handle 10 000+ columns in fastest way( maybe work with a variable that contains the range and than paste it back on the sheet)
- I want to keep the first instance of each column ( for example if we have headers like = " pizza - pizza - burger" I want to keep "pizza - burger" columns)
- I cannot provide an exemple but if more informations are needed I can answer you
Thanks a lot for your help