If you have
A
B
C
and place your cursor on A, it will do font size to
A=12
B=10
C=16

I thought that is what you wanted.???
Offset means down 1. If it was offset(1,2) would be down 1 and to the right
2.

--
Don Guillett
SalesAid Software

"R Doornbosch" wrote in message
...
I can change the font and make it BOLD but the keyword Offset doesn't seem
to do anything.



"Don Guillett" wrote in message
...
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?