Link to home
Create AccountLog in
Avatar of Bright01
Bright01Flag for United States of America

asked on

Creating a Array using Range Names

EE Pros.,

I have a WS that "dynamically" creates range names from newly added columns.  When a column is later deleted, the Range name is also removed.  I am interested in creating an Array on a separate Tab (WS) that is created as columns (Range names) are created or "contracts when range names are deleted (along with the columns).  Shortly I'll have a sample of what I'm trying to accomplish.

Is it doable?

B.
ASKER CERTIFIED SOLUTION
Avatar of Faustulus
Faustulus
Flag of Singapore image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Bright01

ASKER

Great answer!  I have taken your comments and posted the next version of my App.  Hope you will take a look at it.

All the best to you.

B.