Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-16-2017, 03:47 PM
stockers stockers is offline Header over two lines referencing cells Windows 7 32bit Header over two lines referencing cells Office 2010 32bit
Novice
Header over two lines referencing cells
 
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
Reply



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
Header over two lines referencing cells 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft