Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
My code generates a number based on some inputs and then uses that
number as the Tble(0) value and then is trying to create an array using that initial value. I do not know how many rows the array will have, but i don't want it to be bigger then 2550. The next row in the array is based on the previous row. My problem is the lagged specification and the incorrect use of the step function. Can anyone point me in the right direction on this. I will eventually put the created array in some cells to display it. Thanks a bunch. Sub Test() Dim Input1, Input2, Input3, Box As Double Dim Tble() As String Dim rw, x As Integer Input1 = Cells(1, 1).Value Input2 = Cells(2, 1).Value Input3 = Input1 * Input2 Cells(3, 1).Value = Input3 rw = 0 ReDim Tble(rw) Tble(0) = Input3 While Tble(rw) < 2550 For rw = 1 To Step Tble(rw) = Tble(rw - 1) + 1 rw = rw + 1 Next rw Wend End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
creating an array | Excel Worksheet Functions | |||
creating an array | Excel Programming | |||
Creating and using an array | Excel Programming | |||
creating an array on the fly | Excel Programming | |||
Creating an array | Excel Programming |