Help with print area

D

DavidObeid

I am trying to get a print area defined that will run from $O$3 out to
(EOMONTH(P4,0)-P4-1) columns and down to
(COUNTA(O3:O20)-COUNTIF(O3:O20,"")+3) rows.

Why won't this formula work?

=OFFSET(Sheet1!$O$3,0,0,COUNTA(O3:O20)-COUNTIF(O3:O20,"")+3,EOMONTH(P4,0)-P4-1)


Help! I am at my wits end.
 
J

J.E. McGimpsey

this worked for me:

=OFFSET(Sheet1!$O$3,0,0,COUNTA(Sheet1!$O$3:$O$20)-
COUNTIF(Sheet1!$O$3:$O$20,"")+3,EOMONTH(Sheet1!$P$4,0)-Sheet1!$P$4-1)

note that since you didn't give us a clue as to what "this formula
(won't) work" means (do you get errors on entry?, run-time errors?
crashes?), nor which version of XL you're using, this may not work
for you.
 
D

DavidObeid

My apologies.

"This won't work" meant that I was not getting the desired print rang
when I printed. I was getting my whole sheet printed, not just th
range specified.

I tried absolute references (staring at the formula for 30 minutes ha
me in such a zombie like state that I didn't realise my references wer
relative) and it works fine now.

Thanks, and sorry for being so uninformative in my question. I wa
ready to head butt my screen.

Cheers.

Dave
 
Top