Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Need a Before_Print code that will do the following:
1) Maintain 3 header rows set in "rows to repeat at top" 2) Hide rows that do not contain dates for month in A2, dates start at C4 and go down the column, some of which may not have dates entered yet 3) Print the sheet 4) Unhide the rows previously hidden in 2) something like If month(c4:c124)< month(a2) then entirerow.hidden=true Range(visiblerows).printout Range(hiddenrows).visible=true -- David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Print Question? | Excel Discussion (Misc queries) | |||
Do not print one cell question? | Setting up and Configuration of Excel | |||
Another Print Area question | Excel Discussion (Misc queries) | |||
Print Question Newbie Please help | New Users to Excel | |||
Print question? | Excel Discussion (Misc queries) |