Hi Everyone,

I am working now with building a macro for generating a standard hours report, in a worksheet i want to hide a specific period(month) columns, i have in total 12 columns for months, above the row i have a merged cell called "The HOURS" in the range from period 1 to 12, but when i want to hide for example column "period 3 and period 4" with VBA code, it hides all the 12 the colunms due this merged cell.

Which VBA code do i have to use so that only the specified columns should be hide. I dont want to change the merged cell to normal cell.

I used the following VBA code for example


Columns("S:T").Select
Selection.EntireColumn.Hidden = True


I would be pleased if you could help me with this.

Kind Regards,
kilaz17