Assign the column width of one cell to another cell on the active sheet, using:
Sub widthDemo() Range("C1").ColumnWidth = Range("A1").ColumnWidth End Sub