#1
|
|||
|
|||
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* |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Trying to add space between lines of bulleted text and a new header but both lines are moving??? | Martin_d35 | Word | 2 | 02-10-2017 07:13 AM |
Referencing to cells by FormulaR1C1 | Filip88 | Excel Programming | 2 | 01-21-2017 07:51 AM |
Naming Cells for formula referencing | lynchbro | Excel | 6 | 06-26-2014 07:45 AM |
Table cells with negative numbers being displayed in two lines | HankBrandenburg | Word Tables | 1 | 02-17-2014 03:04 PM |
Macro to Insert Text Into Cells Having Multiple Lines | revans611 | Excel Programming | 4 | 10-24-2011 10:15 AM |