Hi,
One method that comes to mind is:-
If you first of all select each row that you don't want to print then you
can hide it using
e.g. ActiveRow.Hidden = True - Hidden rows don't print.
You will also need a small routine to unhide these rows when needed.
Hoping that the above may be of some use,
Regards,
Don Lloyd.
Quote:
> We are currently in the process of moving from Lotus 123 to Excel.
> Does anyone know how to stop rows from printing if they contain zero's ?
> We know this can be done in 123 and is very usefull, but can't find the
> option in Excel.
> Thanks in Advance
> Simon