View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John[_34_] John[_34_] is offline
external usenet poster
 
Posts: 12
Default Define a dynamic Print_Area

I've been searching on the internet and have found just enough tidbits
to get me on the road to frustration

I would like to set up a dyn. Print_Area from A1 to column K(n).
I tried:
1. =INDIRECT("A1:K"&COUNTIF(UK!A:A,"0"))
2. =OFFSET(UK!$A$1,0,0,Countif(UK!$A:$A,"<"&0),11)

The number seems the one that works better but not as I expected.
Where am I wrong?
Thanks for any help
Regards
John