Can't I make a macro to do it for me?
One that creates a name, and loops trough my array, filling in the elements?
Edit: I'm trying out to do this:
But I'm getting application-defined or object-defined error.
Edit 2:
I tried this code for a range of numbers (instead of range of strings (I removed the quotation marks (Chr(34)))), and it works.
So I just need to figure out how to make it work for an array of strings.
EDIT 3: The code actually works. Problem was that my array was too long for the name manager. Fixed that by splitting my array in 2.
Bookmarks