| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text from within a sheet into right header
Howdie, How do I put text from say cell c10 into the right header by using VB...? Thanks D *** Sent via Developersdex http://www.developersdex.com *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Text from within a sheet into right header
Activesheet.PageSetup.RightHeader = Activesheet.Range("C10").Text
-- Regards, Tom Ogilvy "Darin Kramer" wrote: Howdie, How do I put text from say cell c10 into the right header by using VB...? Thanks D *** Sent via Developersdex http://www.developersdex.com *** |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Text from within a sheet into right header
Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.RightHeader = Cells(10, 3).Value End Sub Paste this into ThisWorkbook code, not a standard module -- Gary's Student "Darin Kramer" wrote: Howdie, How do I put text from say cell c10 into the right header by using VB...? Thanks D *** Sent via Developersdex http://www.developersdex.com *** |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Text from within a sheet into right header
Hi
according Excel VBA help by simply searching Header RightHeader Property See Also Applies To Example Specifics Returns or sets the right part of the header. Read/write String. Remarks Special format codes can be used in the header text. Example This example prints the filename in the upper-right corner of every page. Worksheets("Sheet1").PageSetup.RightHeader = "&F"So Worksheets("Sheet1").PageSetup.RightHeader = Worksheets("Sheet1").Range("C10")Regards"Darin Kramer" wrote in message ... Howdie, How do I put text from say cell c10 into the right header by using VB...? Thanks D *** Sent via Developersdex http://www.developersdex.com *** |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| identify sheet number in header? | Excel Discussion (Misc queries) | |||
| can't get sheet to display after editing header | New Users to Excel | |||
| VBA Code to Add the same header from my first sheet into 20 sheets | Excel Worksheet Functions | |||
| Macro with a different Header for each Sheet | Excel Discussion (Misc queries) | |||
| How do I create a new header in Excel once to be used on all sheet | Setting up and Configuration of Excel | |||
Hybrid Mode
