cassidybklyn
Programmer
Could someone please show me how I can put a page header on a spreadsheet, using VB6. Also, I want the header to repeat at every page when printed.
In the routine that does the PageSetup, I don't know if the code below can accomplish that:
With ActiveSheet.PageSetup
.PrintTitleColumns = "Class of 2007"
End With.
Example of how I want the spreadsheet to look:
Class of 2007
-------------
LastName:FirstName:Age:
--------:---------:----
Johnston:Gaberiela:28
Thanks.
C.
In the routine that does the PageSetup, I don't know if the code below can accomplish that:
With ActiveSheet.PageSetup
.PrintTitleColumns = "Class of 2007"
End With.
Example of how I want the spreadsheet to look:
Class of 2007
-------------
LastName:FirstName:Age:
--------:---------:----
Johnston:Gaberiela:28
Thanks.
C.