column selection is different from the one in the code

[Maverick0174]

Hello together,

I've several Hide/Show Buttons for e.g. top row and also for some columns in my sheet.
All except one are working fine. The one doesn't work should select column H to J but the selection is H to K.
It drives me crazy, hope someone has a hint for me........

selectH-K.JPG

And here the code accordingly

Please Login or Register  to view this content.

[:) Sixthsense :)]

May be because of Merged Cells exists in that range which falls upto K column.

[Maverick0174]

May be because of Merged Cells exists in that range which falls upto K column.

Hi, no merged cells in this range. I'm also able to select and hide the columns manually.

[Maverick0174]

There was merged cells in this range but it was hided Thank you for the hint