General discussion

Locked

Use cell value to use in naming ranges

By Nsohenick ·
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

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Comments

Collapse -

Use cell value to use in naming ranges

by DKlippert In reply to Use cell value to use in ...

I think you'll want what is called a dynamic range. Here's a great description:

http://tinyurl.com/9itm

Collapse -

Use cell value to use in naming ranges

by Nsohenick In reply to Use cell value to use in ...

Works great. Thanks!

Collapse -

Use cell value to use in naming ranges

by Nsohenick In reply to Use cell value to use in ...

This question was closed by the author

Back to Windows Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums