Hello,
I m working on VBA code to delete columns if they are completely identical. I have found some solutions but most of them takes too much time.
Here are some information :
- My columns dont have header
- 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 columns ( If we have 2 identitcal columns we need to keep one of them )
- I dont want to check specific columns but the entire sheet
- 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 are completely identical. I have found some solutions but most of them takes too much time.
Here are some information :
- My columns dont have header
- 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 columns ( If we have 2 identitcal columns we need to keep one of them )
- I dont want to check specific columns but the entire sheet
- I cannot provide an exemple but if more informations are needed I can answer you
Thanks a lot for your help