I'm trying to use the following in my defined names:

=OFFSET(Export_Requests.csv!$C$1,0,0,COUNTA(Export _Requests.csv!$C:$C),1)

to define a column of names that is expanding on a daily basis.

But it isn't picking up the last three cells of data. I have similar code in
the adjacent columns with no problems. Has anyone encountered this problem
before and if so, how do I remedy it?