How to set column formatting using a macro? I need to set font size to 11 and text position to center. To make this formatting work automatically in an Excel sheet.
moninah
0
How to set column formatting using a macro? I need to set font size to 11 and text position to center. To make this formatting work automatically in an Excel sheet.
Example for column B (column index 2)
Sub doColumns()
Columns(2).Font.Size = 11
Columns(2).HorizontalAlignment = xlCenter
End Sub