Query Hide State of Column Ranger and Hide if False

Hi,

I believe my query is pretty straightforward but many of the methods I have found relate to PivotTables or do not seem to be quite what I am looking for, so decided to come to the experts.

Basically, I want to create a macro that checks whether a specified range of columns is hidden, and

a) hide them if they are not hidden, or
b) unhide them if they are hidden,

i.e. toggle the Hide state.

What method can I use to query the hidden state of a selected range of columns and return a boolean value?

Many thanks in advance.

Orson.

Amend the columns to suit your workbook

Please Login or Register  to view this content.