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

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