conditional printing macro
 

Each month I have to submit a check request for services
rendered. Each person does not necessarily get a check
each month. I have the check amounts in column s7:s39.
Is there a way to have a macro do the following:

If s70 then print range("XXX")
If s80 then print range("XXX")
....

Thanks,

Joe

conditional printing macro
 

Hi
see:
http://www.rondebruin.nl/print.htm#Hide

--
Regards
Frank Kabel
Frankfurt, Germany


Joe wrote:
Each month I have to submit a check request for services
rendered. Each person does not necessarily get a check
each month. I have the check amounts in column s7:s39.
Is there a way to have a macro do the following:

If s70 then print range("XXX")
If s80 then print range("XXX")
...

Thanks,

Joe