Change font size

[phreud]

Hi all,

I'm trying to change the font size used in a worksheet. Now I change it with UsedRange.Font which works, but I would think there is a better way of doing it?

I want it to change for all cells, like I'm setting a default font for the entire worksheet. It seems a bit slow/stupid to just go through all cells and change the font.

Any help apprechiated!

[theDude]

This is straight from the Visual Basic Help topic Cells Property Example:

This example sets the font and font size for every cell on Sheet1 to 8-point Arial.

With Worksheets("Sheet1").Cells.Font
.Name = "Arial"
.Size = 8
End With

Hope this helps,
theDude

[phreud]

Sweet. Havn't seen 'cells' before. Thanks alot!