Code Bug Fix: Why aren’t columns hidden (Range().Columns.Hidden ) after OLEDBConnection.Refresh?

Original Source Link

I try to Refresh a Connection and then formatting the table.

The second part alone is working, but with Refresh it doesn’t work the way I would expect.
If I use Debug.Print Range(“”).Columns.Hidden it’s true, but i can see the columns in my table.

Do anyone know what’s the Problem?

ActiveWorkbook.Connections(4).OLEDBConnection.BackgroundQuery = False
ActiveWorkbook.Connections(4).OLEDBConnection.Refresh

Rows("25:25").RowHeight = 70
Columns("N:AU").Columns.AutoFit
Range("L:O").Columns.Hidden = True

Tagged : /

Leave a Reply

Your email address will not be published. Required fields are marked *