Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing Grouped Sheets
I have 3 Worksheets which I have "Grouped"
WS01 - has 3 pages of printable stuff WS02 - has 2 pages of ... stuff Ws03 - has 1 page Private Sub Workbook_BeforePrint(Cancel As Boolean) CellInFooter End Sub Public Sub CellInFooter() ActiveSheet.PageSetup.LeftFooter = Range("A1").Value & Page# End Sub Problem? Page# << Not working; Wish for it to print from 1 sequentially to end (page 6). Any help appreciated... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
not printing grouped columns | Excel Discussion (Misc queries) | |||
printing worksheet with cells grouped | Excel Discussion (Misc queries) | |||
Printing Footers on Grouped Worksheets | Excel Discussion (Misc queries) | |||
Printing a group that is not grouped | Excel Discussion (Misc queries) | |||
Sheets(array) method for printing grouped worksheets | Excel Programming |