Hide and unhide every 2nd, 3rd, 4th and 5th column of the data

[sandubandu]

I have data with 200+ columns,
I need a macro that will hide and Unhide every 2nd, 3rd, 4th and 5th column of the data set, Is it possible to make some button for doing Hide and Unhide this columns ?
I have attached reference file.

Thanks in advance

[Bo_Ry]

Please try

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[sandubandu]

Thank you very much !

[sandubandu]

what to do if I want to apply this macro from column number 37 onward, means I don't want first 37 columns get hidden.

[Bo_Ry]

i = 2 hide 2 …
resize(, 4) to hide 2,3,4,5

i = 37 hide 37 …
resize(, 4) to hide 37,38,39,40

Copy to clipboard

Please Login or Register  to view this content.