View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
driller driller is offline
external usenet poster
 
Posts: 740
Default lookup for bright solution...

hello again,

i have posted these before in other forum..i forget that this may be a
little complicated in this forum...

in myWorkbook i have many sheets,
the sheet names has no typical name pattern

is it possible to print the group of sheets in one command under a typical
criteria.
that is, *print the sheet if cell A1=0*, yet the footer page numbers must be
maintained.

If the there are 30 sheets in the grouptab, while 10 sheets contains *A10*,
then only sheets will be printed.

The footer paging SEQUENCE numbers shall correspond to the arrangement of
the sheets (L to R) in the workbook regardless of the above criteria....

hope its simple.<saving trees!

regards,
driller
--
*****
birds of the same feather flock together..