Unhiding Columns with UsedRange

[reberryjr]

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.

With sD.UsedRange
    If .EntireColumn.Hidden = True Then .EntireColumn.Hidden = False
    If .EntireRow.Hidden = True Then .EntireRow.Hidden = False
End With

 

[johnnyL]

How about:

With sD.UsedRange
    .Columns.EntireColumn.Hidden = False
    .Rows.EntireRow.Hidden = False
End With

 

[reberryjr]

How about:

With sD.UsedRange
    .Columns.EntireColumn.Hidden = False
    .Rows.EntireRow.Hidden = False
End With

Thought I would need an IF statement since when I try to unfilter, I get an error if there's no filter. This route works, so thank you!

 

[johnnyL]

Glad to help.