Custom font size for specific range only

[ipbr21054]

Hi,

I have some values that when printed are to small.
So i wish to enlarge the Font size to say 20 BUT only within a specific range as to not change row height on the same row of which are Font size 12
Is that possible ?

Example.

Range A1:A20 Font size 12

Range A24:A30 Font Size 20

Currently if i use A24:A30 Font Size 20 the row height alters thus affecting A1:A20

If the above cant be done then maybe using the range create a pdf, Then Print pdf as a work around.
Not sure how i would alter size of text on the pdf though ?

Currently using this to print.

VBA Code:
Private Sub PrintOutRange_Click()
Range("T1:X20").PrintOut
ActiveSheet.PageSetup.Orientation = xlPortrait
End Sub

Thanks.

 

[Jeffrey Mahoney]

Maybe I don't fully understand, it is not usual for Excel to automatically change the row size for all rows when you only change the font in some rows.

Book2
	A	B
1	Font Size	Row Height
2	12	15.6
3	12	15.6
4	12	15.6
5	12	15.6
6	12	15.6
7	12	15.6
8	12	15.6
9	12	15.6
10	12	15.6
11	12	15.6
12	12	15.6
13	12	15.6
14	12	15.6
15	12	15.6
16	12	15.6
17	12	15.6
18	12	15.6
19	12	15.6
20	12	15.6
21
22
23
24	20	25.8
25	20	25.8
26	20	25.8
27	20	25.8
28	20	25.8
29	20	25.8
30	20	25.8
Sheet2

Cell Formulas
Range	Formula
B2:B20,B24:B30	B2	=RowHeight(A2)

 

[ipbr21054]

If you read my text again you will see its on the same row.
You example shows different rows