Font Size in VBA

[Secret Squirrel]

How can I change the font size on my entire worksheet via VBA?

 

[papou]

Hello
Worksheets("Sheet1").Cells.Font.Name = "Tahoma"

HTH
Cordially
Pascal

 

[FSt1]

hi
activesheet.cells.font.size = 10

or mayby just
cells.font.size = 10

regards
FSt1