Using Excel 2013, I have the following Macro:
If I do the commands manually, that is:
Select the Worksheet
Refresh All the Data
Press <Alt> OCA (to do AutoWidth)
The commands work. BUT in a macro, zippo, nada, zilch, nothing. Refresh works but the columnwidth will not go back.
Any thoughts would be greatly appreciated.