View Single Post
 
Old 03-16-2017, 03:47 PM
stockers stockers is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Mar 2013
Posts: 4
stockers is on a distinguished road
Default Header over two lines referencing cells

G'day

Wondering if anyone can help, I've currently got this code working:

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
ActiveSheet.PageSetup.RightHeader = "Incident Name: " & Worksheets("Main Page").Range("E7").Text
End Sub

and I want to add this into the header below the above code:

"Incident Number: " & Worksheets("Main Page").Range("E8").Text

So effectively the right header will read:
Incident Name: *Main Page E7*
Incident Number: *Main Page E8*
Reply With Quote