Update offset Print Area

[Livin404]

When I created a print area in my Name Manager I had to Offset it so It will select all the areas that will have text. Because I have a format where rows alternate colors it is selecting all the rows.
I only want it to select the rows with Text.

The formula I'm using in Name manager is

=OFFSET('Training Criteria'!$A$4,0,0,COUNTA('Training Criteria'!$I:$I),9)

I only one it to go down to Tanner Damari A...

Here is what the image currently is and it goes on for 86 pages.

Names & Numbers are fictional

Thank you,

 

[Livin404]

I have some good news I got it a lot closer. It is capturing everything I need except the last row. It is only going down to Reilly Alvaro H.
The updated formula is

=OFFSET('Training Criteria'!$A$4,0,0,COUNT('Training Criteria'!$I:$I),9)

The new image is

 

[Eric W]

The COUNT part of your formula counts the numeric values in column I, the Phone Numbers. You have 4 numbers, and one text heading. And since you're starting at the heading (A4), you only get 4 lines 4,5,6,7. If you want to get the last line, then either add 1 to the COUNT

=OFFSET('Training Criteria'!$A$4,0,0,COUNT('Training Criteria'!$I:$I)+1,9)

or use COUNTA instead, which counts all non-blank cells.

=OFFSET('Training Criteria'!$A$4,0,0,COUNTA('Training Criteria'!$I:$I),9)

The reason your formula didn't work the first time is probably because you had some non-empty cells below your data. The way your formula is written, make sure there is no data in rows 1,2,3 or after your table.

 

[Livin404]

Thank you, I went with your first solution. Though I tried your second one which looked like my original one, and it was still capturing all those line underneath the last row. I don't know why; it works for years.
The first solution it appears to be working, so again thanks!