karolina1406
Board Regular
- Joined
- Apr 18, 2016
- Messages
- 110
- Office Version
- 365
- Platform
- Windows
I am using the below code to refresh my Query table and it's fine other than columns width always comes back to "original" no matter how much I try to adjust them and what value/text is in the table. for clarity, columns :D are not set to 25 after refreshing Can someone help?
VBA Code:
ThisWorkbook.RefreshAll
With Worksheets("ChangeRequests").Columns("b:d")
.ColumnWidth = 25
End With