header
Hi,
Excel doesn't allow you to link a cell address to the header or footer (you
could in Lotus 1-2-3 version 1)?
1. One alternative is to choose File, Page Setup, Sheets tab and define a
row(s) as header row(s).
2. Second alternative is to use a macro of the following type
The following code puts the contents of cell A1 of Sheet1 into the left
heade
Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.LeftHeader = Sheets("Sheet1").Range("A1")
End Sub
1. To add this code to your file, press Alt+F11,
2. In the VBAProject window, top left side, find thisWorkbook under your
file name and double click it.
3. Paste in or type the code above.
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Hoov" wrote:
How do you make a header out of your data from Cell #1? I tried to copy and
paste, but the formatting was way off, and the actual cells didn't appear.
Please help me with this if you know how. Thanks so much.
|