Font Size in VBA

  • Thread starter Thread starter Secret Squirrel
  • Start date Start date
S

Secret Squirrel

How can I change the font size on my entire worksheet via VBA?
 
Hello
Worksheets("Sheet1").Cells.Font.Name = "Tahoma"

HTH
Cordially
Pascal
 
hi
activesheet.cells.font.size = 10

or mayby just
cells.font.size = 10

regards
FSt1
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using VBA to rearrange data 0
Happy Birthday Ian 4
Happy Birthday Abarbarian 8
Happy Birthday Muckshifter 6
Happy Birthday V_R 7
Visual Basic (Word) doesn't recognize "My" as in My.Application.FileSystem.RenameFile 2
Excel VBA - Problem with Closing Print Preview 0
Duplicate Line by cell qty 1

Back
Top