Use cell value to use in naming ranges

I am using a macro to name ranges in Excel. Right now I am going down 150 records, which should be plenty of room to capture all possible data. But you never know. I could go to 1000, but then the PRN file it create will create a 1000 line file with5 records.

I have a countif field in row # 655239 that is counting how many rows have data. I want to take that number and use it when naming the ranges.

Is that possible? If so, how?

Thanks