Using Right(cellsxxxxxx) in LeftHeader

[chefdt]

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

ActiveSheet.PageSetup.LeftHeader = _
    Format(Worksheets("SHEET 1").Right(Cells(1, 9), 7).Value)

 

[MARK858]

Assuming your SHEET 1 is actually Sheet1 try

Sub xxxxff()
ActiveSheet.PageSetup.LeftHeader = _
    Right(Worksheets("Sheet1").Cells(1, 9), 7)
 ActiveSheet.PrintPreview
End Sub

 

[chefdt]

I'm screaming......perfect!

Learned a lot!

 

[MARK858]

I'm screaming

You don't want to do that, it might wake the neighbours

Happy it helped.