conditional printing macro

J

Joe

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 s7>0 then print range("XXX")
If s8>0 then print range("XXX")
....

Thanks,

Joe
 
Top