Hide all columns doesn't work

[YasserKhalil]

Hello everyone

I am trying to unhide all the columns with this line of code

Code: Select all

ws.Columns.Hidden = False

This works well. While replacing the False with True throws an error.
How can I hide all the columns in the worksheet without throwing errors?

I tried such line and works fine

Code: Select all

.Cells(1, 10).Resize(, .Columns.Count - 9).EntireColumn.Hidden = True

But I still need to hide all first before unhiding specific columns.

[HansV]

ws.Columns.Hidden = True works for me. What is the error message?

[YasserKhalil]

I found that the comments in the first row were the cause of the error. When deleting all the comments, it worked well.
Thanks a lot, my tutor.