[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 150
  • Last Modified:

Range Names on Sort

EE Pros,

I'm perplexed about a situation with range names and referring to them.

If I create an array and sort by Column A to get "like" cells aligned, then create ranges on each group of "like" cells, then I can call those ranges by name in a macro.  What if I then take my array and sort it by another column, say Column B.  Now the contiguous rows that were in the original array are no longer in the array contiguously.  What happens when I then refer to the range name in the macro?

B.
0
Bright01
Asked:
Bright01
  • 2
  • 2
1 Solution
 
MacroShadowCommented:
The named range remains the same regardless of whether it's visible or not.
0
 
Bright01Author Commented:
Just so I'm clear.... if I add another row, and I intend for it to be included in the range, I must resort the list and add a row within the range in order that it will be included?  If I add a new row at the end of the data/list, it will not be included in any "range".  Is that right?

Thank you,

B.
0
 
MacroShadowCommented:
Just so I'm clear.... if I add another row, and I intend for it to be included in the range, I must resort the list and add a row within the range in order that it will be included?
Correct.

If I add a new row at the end of the data/list, it will not be included in any "range".  Is that right?
In a normal named range, correct. in a dynamic named range, wrong.
Dynamic ranges will expand with the data added under them, an example of a simple dynamic range is a table. Dynamic ranges are a complex topic, with many ways of creating them. They deserve their own special attention.
0
 
Bright01Author Commented:
Thank you!

B
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now