my variable RefNum doesn't pass to the Page Header
If I don't include the formatting info it works but I'd like it fomatted![]()
RefNum = InputBox("What is the Reference Number?") Sheets("Image").Select With ActiveSheet.PageSetup .LeftHeader = "&""Arial,Bold""&14RefNum" End With
![]()
.LeftHeader = RefNum
Bookmarks