Posted to microsoft.public.excel.programming

Al[_19_]

external usenet poster

Posts: 6

create array

There must be a better way of doing this....

Dim vv(10) As Integer
vv(1) = 1
vv(1) = 3
vv(1) = 4
vv(1) = 5
vv(1) = 7
vv(1) = 17
vv(1) = 18
vv(1) = 19
vv(1) = 20
vv(1) = 21
vv(1) = 22

Can't I do something like:
Dim vv(10)
vv() = (1,3,4,5,7,.....)

Al

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using Loop to create Array	davidm	Excel Programming	4	June 15th 05 11:41 AM
how do I create an array	lost	Excel Discussion (Misc queries)	6	April 7th 05 12:43 AM
how do I create an array	array_deficient	Excel Discussion (Misc queries)	0	April 6th 05 09:53 PM
Create array function	Yuriy Kuznetsov	Excel Programming	2	November 2nd 04 03:05 PM
Create a PivotTable from a VBA array?	Dave[_15_]	Excel Programming	0	August 9th 03 12:58 PM

All times are GMT +1. The time now is 11:28 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us