checking for hidden columns
I don't think you need a macro to do that, just do:
If Not Columns(iCol).EntireRow.Hidden Then
Columns(iCol).EntireRow.Hidden = True
End If
But even that I quit doing long ago. Except in cases of heavy computation
where it's best to check first if something needs to be done, I've found it's
simpler just to do
Columns(iCol).EntireRow.Hidden = True
and not worry about if it is already hidden. The above statement uses so
little CPU time it's irrelevant whether or not it's already hidden.
"stickandrock" wrote:
I want to create a macro that will validate whether a column is hidden or
not. I can make column hidden and/or unhide columns, but it is redudant if
they are already in the state that I need them.
Thank you for any and all input.
|