Discussion Locked

Use cell value to use in naming ranges

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

3 replies

This discussion is closed to new replies.