Thread
:
change font size and bold in cell?
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
change font size and bold in cell?
Sub setfont()
With ActiveCell
..Font.Size = 12
..font.bold=true
..Offset(1).Font.Size = 10
..Offset(2).Font.Size = 16
End With
End Sub
--
Don Guillett
SalesAid Software
"R Doornbosch" wrote in message
...
When I use
Worksheets("Teacher Info").Range("A1").Value = "Teacher Information
AM Class"
How can I make it so the first line is Font 12 (Bold)
the second line if Font 10
Third line is font 16?
All of this information is in the same cell?
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]