How to omit certain worksheets in a series from printing

[Macro Solutions]

I have set up a macro to print several worksheets in a Excel workbook.
How do I omit a sheet fom printing if it reflects a zero value in a certain
cell

[galimi]

You can surround the print macro with the following condition.

If range("range").value <> 0 then

print macro here...

end if

range("range") should be replaced with the range/cell you are referencing.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Macro Solutions" wrote:

> I have set up a macro to print several worksheets in a Excel workbook.
> How do I omit a sheet fom printing if it reflects a zero value in a certain
> cell