Thread
:
Quickest Way of making an Array
View Single Post
#
5
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Quickest Way of making an Array
if you don't need commas in between
ma = ActiveSheet.Range("a1:a6").Value
--
Don Guillett
SalesAid Software
"WhytheQ" wrote in message
ups.com...
1
2
3
4
5
6
What is the quickest way of putting the above into an array?
The above numbers are located on sheet1 range("A1:A6")
I use what I believe is the normal way of filling the array i.e a For
Next Loop - but maybe there are better ways of going about it?
Regards,
Jason.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett