I've spent way too much time trying to figure this out and need some help.
Trying to force my header to read the RIGHT 7 characters from cell I1
Trying to force my header to read the RIGHT 7 characters from cell I1
Code:
ActiveSheet.PageSetup.LeftHeader = _
Format(Worksheets("SHEET 1").Right(Cells(1, 9), 7).Value)