| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Define a dynamic Print_Area
Hi John,
Am Sun, 13 Jan 2013 11:32:15 +0100 schrieb John: 1. =INDIRECT("A1:K"&COUNTIF(UK!A:A,"0")) 2. =OFFSET(UK!$A$1,0,0,Countif(UK!$A:$A,"<"&0),11) try: =OFFSET(UK!$A$1,,,COUNTA(UK!$A:$A),11) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Define Dynamic Name | Excel Discussion (Misc queries) | |||
| How to Define and Use a Dynamic Array | Excel Programming | |||
| dynamic search in the Define Name window | Excel Discussion (Misc queries) | |||
| Define a variable for dynamic chart | Excel Programming | |||
| Define a Dynamic Range Based on an Index | Excel Programming | |||
Threaded Mode
