This code isn't working. Will I need to loop through all of the columns and unhide them? I was hoping to avoid a loop, as I have about 30 files I need to do this with, plus other code:
I've verified that panes aren't frozen.
I've verified that panes aren't frozen.
VBA Code:
With sD.UsedRange
If .EntireColumn.Hidden = True Then .EntireColumn.Hidden = False
If .EntireRow.Hidden = True Then .EntireRow.Hidden = False
End With