Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Does anyone know the code to put a number in the right header...
Does anyone know the code to put a number in the right header and have the
number change everytime you print? This number has nothing to do with the worksheet itself, it is a totally different number. This is what I am using to do the regular printing in the spreadsheet and would like it to be changed for the right header only no cell reference: Private Sub Workbook_BeforePrint(Cancel As Boolean) If ActiveSheet.Name = "Sheet1" Then ActiveSheet.Range("K1").Value = ActiveSheet.Range("K1").Value + 1 End If End Sub Thanks sorry for the double post but I haven't received an answer to help me. Jennifer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what code pulls in contents of a cell in an Excel header/footer? | Excel Discussion (Misc queries) | |||
Does anyone know the code to put a number in the right header and. | Excel Discussion (Misc queries) | |||
Does anyone know the code to put a number in the right header... | Excel Discussion (Misc queries) | |||
Convert a Number Code to a Text Code | Excel Discussion (Misc queries) | |||
VBA Code to Add the same header from my first sheet into 20 sheets | Excel Worksheet Functions |