I currently am working on a vba script to try to get the right side of my header to look like this:


Week of:

xx/xx/xxxx -xx/xx/xxxx

I currently have this:
ActiveSheet.PageSetup.RightHeader = _
"&""Times New Roman,Bold""&12Week of:&""Arial,Regular""&10" & Chr(10) & "" & Chr(10) & "&""Arial,Bold""&U ActiveSheet.Range("C29")" & Chr(10) & "" & Chr(10) & "" & Chr(10) & "&""Arial,Regular""&U" & Chr(10) & ""


End Sub


please note the xx/xx/xxxx -xx/xx/xxxx is a date that is pulled from a cell located in C29, that is why I am using the command ActiveSheet.Range("C29")

Any help in this would be great!