| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Including Spreadsheet Date in a header
Is there any (preferable easy) way to to automatically
include the contents of a specific cell in the custom header information? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Including Spreadsheet Date in a header
Hi Steve,
Don't know about preferable, but the following should work Activesheet.PageSetup.LeftHeader = Range("B2").value More information on headers and footers in http://www.mvps.org/dmcritchie/excel/pathname.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Steve" wrote in message ... Is there any (preferable easy) way to to automatically include the contents of a specific cell in the custom header information? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort a worksheet without including the column header row | Excel Discussion (Misc queries) | |||
| Concatenate including a date so that the date appears as a date | Excel Worksheet Functions | |||
| How do I filter data without including the header row? | New Users to Excel | |||
| How do I copy the print settings, including header and footer fro. | Excel Discussion (Misc queries) | |||
| Can't Get data without including Header using ADO | Excel Programming | |||
![Steve[_61_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
