View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brian Brian is offline
external usenet poster
 
Posts: 683
Default macro to print sheets from wrkbk only if data has been typed in

I have a workbook that has 24 tabs on it. It is used to evaluate people. An
evaluator will evaluate up to 24 people. But not the max all the time. If
thhey only do say 10, then I only want to print 10 from that workbook. The I
might open 16 workbooks on an evaluation day and need to print only the
worksheeets that have been typed onto. Is there a way to do an if command in
a macro?