Cyberdude
11-10-2005, 11:36 AM
I have a range of three cells in a column ["Range("A1:A3"] to which I want to assign three constant values [1, 2, 3].
My first inclination was to write the statement:
Range("A1:A3") = Array(1, 2, 3)
which of course is incorrect. To use the "Array" function, I have to assign the values to an array variable (probably a variant). My question is: Can I do an assignment without using an array variable ... a statement that looks something like the statement shown above. I'm wondering if I can do the job with one statement without using an array variable as the target. Hmmmm??
My first inclination was to write the statement:
Range("A1:A3") = Array(1, 2, 3)
which of course is incorrect. To use the "Array" function, I have to assign the values to an array variable (probably a variant). My question is: Can I do an assignment without using an array variable ... a statement that looks something like the statement shown above. I'm wondering if I can do the job with one statement without using an array variable as the target. Hmmmm??