View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KC KC is offline
external usenet poster
 
Posts: 107
Default Print Button with Criteria

I have a tab in my workbook that I want to print with a print button.
However, it needs to print depending on certain criteria. Such as, if Cell
E6 = "SMB" then print A1:P39, if Cell E6 = "KRT" then print A1:R39, if Cell
E6 = "BRS" then print A1:T39. Is it possible to do this?