Convert string array to variant array, or "Array("111", "222")" to Array("111", "222")

[Rowland Hamilton]

Folks:
I used a method to create an array that is actually a string, and captured account numbers (text values) like this:

strArray = "Array("111", "222", "333")"
[End CODE]

But I want to convert it to a variant like:
[CODE]
vntArray = Array("111", "222", "333")
[End CODE]

so that I can use LBound and UBound code on the array.

How do I do this?

Originally, I tried to use the string, but after getting runtime error type 13 mismatch, I manually copied the debug.print of the array, and redefined it without the leading and trailing quotes, and stopped getting the error.

Also, how do you widen the code windows when you post?

Thanks, Rowland

 

[Rowland Hamilton]

Thanks, I realized was probably a bad question, because I hadn't yet changed the code to consider the new dynamic method. Once I started to, I realized I would have to just change the code to add 1 to the named range search. ie Budget(x+1) = vntArray(x)