Font question

[verluc]

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

 

[verluc]

On 2002-04-22 14:42, James wrote:
It looks like the problem is that you have 2
"End With" , remove 1 and it should be fine

James

Very,Very sorry,but it doesn't work.
What I want is that the text in Column A is on the left of the cell and not in the middle of on the right in the cell.
Thanks

 

[verluc]

On 2002-04-22 15:06, verluc wrote:

On 2002-04-22 14:42, James wrote:
It looks like the problem is that you have 2
"End With" , remove 1 and it should be fine

James

Very,Very sorry,but it doesn't work.
What I want is that the text in Column A is on the left of the cell and not in the middle of on the right in the cell.
Thanks

Sorry James,I have found the error.Now it works like I want that it works.
Many,Many thanks for your time.