Hello, my worksheet has 1096 rows of data including headers. I am trying to create dynamic named ranges using the OFFSET function but when I check to see if they are capturing the entire range I see they are not.

Here is my formula:

OFFSET(SiteTrac!$FA$1,0,0,COUNTA(SiteTrac!$FA:$FA),1)

OR

OFFSET(SiteTrac!$FA$1,0,0,COUNTA(SiteTrac!$FA:$FA)-1,1)

OR

OFFSET(SiteTrac!$FA$1,0,0,COUNTA(SiteTrac!$FA:$FA)-1)

OR

OFFSET(SiteTrac!$FA$1,0,0,COUNTA(SiteTrac!$FA:$FA))

I have tried all four but every time it continues to stop on row 409. I have tried to name different columns and they all stop short too.

Any ideas?

Thanks!