Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to be able to access any number that is stored in the UL(j) or
LL(j) array after the function Test remove all the empty rows in the UpperLimit(i) or LowerLimit(i). I will present the user with a combo box located on the excel worksheets. Sub DropDown4_Change() If Range("f13") = 1 Then Application.ScreenUpdating = False Range("c1") = Test(1) Application.ScreenUpdating = True End If End Sub that sub check to see which choice the user selected then i proceed to call the test function and pull out a particular # that is stored in the UL(j) or LL(j) array and then do some calculations. But it doesn't matter which index # (of j) i passthrough the function Test() I always get the last # of the array. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Passing an array in a user defined function | Excel Programming | |||
Passing array from Access to Excel function | Excel Programming | |||
Passing an array as argument for custom Function | Excel Programming | |||
Passing array of strings from DLL function to VBA | Excel Programming | |||
Passing array to a function | Excel Programming |