Posted to microsoft.public.excel.misc

John[_34_] John[_34_] is offline

external usenet poster

Posts: 12

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Define Dynamic Name	kal4000	Excel Discussion (Misc queries)	12	June 26th 08 04:36 PM
How to Define and Use a Dynamic Array	Chaplain Doug	Excel Programming	5	December 4th 07 09:19 PM
dynamic search in the Define Name window	Miri	Excel Discussion (Misc queries)	0	January 17th 07 07:58 AM
Define a variable for dynamic chart	VH	Excel Programming	3	March 2nd 06 11:58 AM
Define a Dynamic Range Based on an Index	Mike Roberto	Excel Programming	4	August 5th 04 02:02 PM

All times are GMT +1. The time now is 02:06 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us