Automaticaly adjust Column Width

[howard]

I have several slicers on one Sheet. If I select one ite on one of the slicers, then some of the column Widths are too small

I would like to know how to prevent this from getting too small when using slicers so that #### does not appear

 

[PritishS]

Maybe this can help

'AutoFit All Columns on Worksheet
ThisWorkbook.Worksheets("Sheet1").Cells.EntireColumn.AutoFit

Regards,
PritishS

 

[howard]

Thanks for your input

 

[PritishS]

Welcome!!