Thread: Cell Value to exact location on a Header
View Single Post
 
Old 08-03-2018, 11:24 AM
Glitch Glitch is offline Windows 7 64bit Office 2016 for Mac
Novice
  
Join Date: Jul 2018
Posts: 12
Glitch is on a distinguished road
Default Cell Value to exact location on a Header
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!
Last edited by Glitch; 08-03-2018 at 02:18 PM.
Reply With Quote