How do i set the font for the active sheet.

[jjyxk845]

Am i being stupid?

How do i set the actice sheets font ?

I've tried

Activesheet.font.name="times new roman" to no avail.

Please can some body point me in the right direction!

 

[SydneyGeek]

Very close, but Font is not a property of the Activesheet, rather of its Cells property (among others).
Use

Activesheet.cells.font.name="times new roman"

instead
Denis

 

[jjyxk845]

cheers!