What is the syntax to change column width?

Columns(“<column letter>”).ColumnWidth = <width in pixels>

Bear in mind that standard column width in Excel is 15.

‘examples
Columns(“B:D”).ColumnWidth = 32

 

Advertisements