View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bennyob
 
Posts: n/a
Default select sheets for printing

Can anyone tell me how to select sheets in a workbook based on a cell value
for printing?
I have many sheets, I want to select all the sheets that have a value
greater than 0 in C2 for printing, which I guess will then go something like:
ActiveWindow.SelectedSheets.PrintOut
Thanks in advance for help
Benny