Pagesetup format code in vba

[challa_praveena]

Hi,

can someone help me to find out how to change the font format in vba code for excel pagesetup option

my code looksl something like this:

For Each oWorksheet In ActiveWorkbook.Worksheets

With oWorksheet.PageSetup
.CenterHeader = "HELLO"
End With
Next oWorksheet

i am suposedto change the font size as 12,type as "ARIAL" and type as "BOLD"

thank u

 

[Ivan F Moala]

On 2002-08-28 21:48, challa_praveena wrote:
Hi,

can someone help me to find out how to change the font format in vba code for excel pagesetup option

my code looksl something like this:

For Each oWorksheet In ActiveWorkbook.Worksheets

With oWorksheet.PageSetup
.CenterHeader = "HELLO"
End With
Next oWorksheet

i am suposedto change the font size as 12,type as "ARIAL" and type as "BOLD"

thank u

This may help...if not then Turn your macro recorder on and see what you get...



<pre/>
'The line below will print the words "header text" underlined
'and in font size 24. Even though the CenterHeader is
'indicated, the "&L" will force it to the left.

'ActiveSheet.PageSetup.CenterHeader = "&L&U&24header text"

'This line of code will format the words, "my text", in the
'font Arial and use Bold. Notice that each piece is enclosed in
'quotation marks.

ActiveSheet.PageSetup.RightHeader = "&""arial,bold"""