Thread: Can't We Set Print Area with condition?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RAZ RAZ is offline
external usenet poster
  
Posts: 120
Default Can't We Set Print Area with condition?
thanks, but I could not find where to add this
please explain where to type this equation or function you wrote. (I am
using excel 2007)
thanks.

"Glenn" wrote:
Try this for Print_Area definition in the Define Name dialog:

=INDIRECT("A1:F"&COUNTIF(Sheet1!A:A,"0"))

Reply With QuoteReply With Quote