In a macro I can have a line like
that quickly puts all of the values in the range into the variant x.
Now suppose I have a variant y with 65000 values that I want to put to range("A1:A65000"). How can I do that without a do loop? range("A1:A65000") =y fails.