Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi!!
I'm using the code below to set the headers on all worksheets in the workbook that have the name Adjustments in it. I need to change this code to set this same header (as below) to all worksheets in the active workbook except for any worksheets with the name "Acct Info" (There could be Acct Info (2), Acct Info (3) and so on...) I'm not sure how to do this .... Sub PrintHEADERAdjustment() 'Set Print Header on Adjusmtents sheets Dim sh1 As Excel.Worksheet Dim sh As Excel.Worksheet Set sh1 = ActiveWorkbook.ActiveSheet For Each sh In ActiveWorkbook.Worksheets sh.Activate If InStr(1, sh.Name, "Adjustments", vbTextCompare) Then sh.PageSetup.CenterHeader = "&""Arial,Bold""&11" & "Insurance Co: " & Range("Insurance_Co").Value & " " & "Policyholder: " & Range("Policyholder").Value & Chr(10) & "Policy No: " & Range("Policy_No").Value & Chr(10) & "Policy Period " & Range("From").Value & " " & Range("To").Value End If Next 'sh sh1.Activate Set sh1 = Nothing Set sh = Nothing End Sub As always.. Thanks in advance for your help, Kimberly |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Setting up Default Headers/Footers in Excel | Excel Discussion (Misc queries) | |||
setting up common headers | New Users to Excel | |||
Setting more parameters with Print area code | Excel Programming | |||
Setting sheet names as headers with page numbering | Excel Programming |