ExcelBanter - Font Size in VBA

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Font Size in VBA (https://www.excelbanter.com/excel-discussion-misc-queries/204770-font-size-vba.html)

Secret Squirrel

Font Size in VBA

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

papou[_4_]

Font Size in VBA

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

HTH
Cordially
Pascal

"Secret Squirrel" a écrit dans le
message de news: ...
How can I change the font size on my entire worksheet via VBA?

FSt1

Font Size in VBA

hi
activesheet.cells.font.size = 10

or mayby just
cells.font.size = 10

regards
FSt1

"Secret Squirrel" wrote:

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

All times are GMT +1. The time now is 01:46 AM.