complicated command button
 

I am trying to program a command button to print only the pages that have
information on an excel spreadsheet. The number of pages I need to print
will change from week to week. I tried the "if else" command, but it is
still printing all pages. Any help would be appreciated

Thank you

Lion

complicated command button
 

We need more info... Is it a matter of you have a single worksheet that you
are printing. That worksheet contains a bunch of formulas that return blanks
and those formulas returning blanks are getting printed???
--
HTH...

Jim Thomlinson


"Lion" wrote:

I am trying to program a command button to print only the pages that have
information on an excel spreadsheet. The number of pages I need to print
will change from week to week. I tried the "if else" command, but it is
still printing all pages. Any help would be appreciated

Thank you

Lion