Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Array Population with a Single Line of Code
I'm trying to figure out how to populate an array variable
in VBA without using something similar to the code below: ReDim a(1 To 4) a(1) = 2 a(2) = 3 a(3) = 5 a(4) = 7 Can this be done with a single line of code? Also, can I populate a single section of a multidimensional array with something like the following? beta(7,3 to 14)= ..... the values for those points in the array Any help is certainly appreciated. I've been doing this the long way for years, and it is driving me crazy! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ? | Excel Worksheet Functions | |||
auto population based on single cell entry | Excel Discussion (Misc queries) | |||
how do you execute single line of code? | Excel Discussion (Misc queries) | |||
Way to change a single line of vb code in several hundred excel files? | Excel Programming | |||
Way to change a single line of vb code in several hundred excel files? | Excel Programming |