I have a sheet who I want the column A make bold.See the following macro I wrote:
With Cells(10, 1).Font
.Name = "Arial"
.Size = 10
.FontStyle = "Bold"
End With
In this macro only the cell of row 10 change in bold.I want to have all the cells in column A change in bold,but I don't know in advance ho many rows there are.It is variable.
Anyone a solution on this.
Many thanks
With Cells(10, 1).Font
.Name = "Arial"
.Size = 10
.FontStyle = "Bold"
End With
In this macro only the cell of row 10 change in bold.I want to have all the cells in column A change in bold,but I don't know in advance ho many rows there are.It is variable.
Anyone a solution on this.
Many thanks