I have several Pivot tables and slicers on this sheet.
When I select any one of the slicers some columns are tooo small resulting in in #### being displayed
I have set up the following code on sheet Monthly Data to prevent this from happening after selecting a slicer
It would be appreciated if someone could assist me. The Data Range if from Col A to AD
When I select any one of the slicers some columns are tooo small resulting in in #### being displayed
I have set up the following code on sheet Monthly Data to prevent this from happening after selecting a slicer
It would be appreciated if someone could assist me. The Data Range if from Col A to AD
Code:
Private Sub Worksheet_Activate()
Sheets("Monthly Data").Cells.EntireColumn.AutoFit
End Sub