D
David
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
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