Hello all,

I am currently trying to have the center header update based on two cell values. The one cell updates based off of another cells value and that is what needs to be updated in the header. I'd like it to update only when that specific cell updates and not each time a cell in the sheet in changed. Here is what I currently have but nothing seems to be working properly.

Private Sub Worksheet_Change(ByVal Target As Range)
 If Target.Address = "$c$22" Then
    With ActiveSheet.PageSetup
        .CenterHeader = Range("v2").Value & Range("w2").Value
    End With
 End If
End Sub
C22 is the cell that I'm typing into and changes the value of W2. V2 and W2 are what I want to appear in the header.

Thanks for the help.