Alright so what I'm trying to do is standardize a workbook. I want to reference a cell in sheet 21. The way the formula is currently set up, it looks at cell A100 in the current active sheet. I want the macro to reference cell C3 in sheet 21 or my input sheet.
Here's the code
Thanks for your help!
Dim ws As Worksheet
Application.ScreenUpdating = False
For Each ws In ActiveWorkbook.Worksheets
Application.StatusBar = "Changing header/footer in " & ws.Name
.CenterHeader = _
"&""Arial,Regular""&18&K000080 &U&K000080" & Range("a100").Value
Set ws = Nothing
Application.StatusBar = False