Thread: Excel 2000 Dynamically Set Print Area
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bill Manville Bill Manville is offline
external usenet poster
  
Posts: 473
Default Excel 2000 Dynamically Set Print Area
Tom Farrell wrote:
Is there a way
to adjust this offset to disregard the cells with forulas and set the
print area to just imported/filled data?


Try replacing
COUNTIF(Sheet2!$A:$A,"<")
with
COUNTA(Sheet2!$A:$A)-COUNTIF(Sheet2!$A:$A,"")

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup

Reply With QuoteReply With Quote