Yeah, would need it to be automatic as the number of rows to print would
vary. Is it possible to use offset here?

ks.

"ager_merityme" wrote:

meant =if(a2<100,a1+1,"")

ks.

"ager_merityme" wrote:

First, I'm working in an evironment where I cannot use macros.

I have a table showing ages in column A and various information to the right
of the ages with a summary line on row 82. The age column changes based on
actual persons age going up to 100. For instance, if the person is 55 then
the age column only fills down to row 46 using =if(a2<10,a1+1,"").

In this case, is there a way to get Excel, again without macros, to print
the document without the subsequent 'blank' rows where the summary line will
show just below the last actual age?

ks.