Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hello guys, i have a problem with an bi-dimensional array.
This is my code I declared a array dim fee(1 to 2, 1 to 4) as string Dim i as integer Fee(1, 1) = "mgt" Fee(1, 2) = "admin" Fee(1, 3) = "mgt_mgt" Fee(1, 4) = "othersfees" For i = 1 To 4 'in order to evaluate this formula i need the fee name and client code StrFormula4 = "Fees(""" & Fee(1, i) & """,""" & Client& """)" Fee(2,i) = Evaluate(StrFormula4) Next i msgbox fee(2,i) ' I and once the formula evaluate I need the result. I do not know very well manipulating arrays; could someone help me on that Ina |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional IF formula using multi-dimensional arrays | Excel Worksheet Functions | |||
Transposing from two dimensional to one dimensional | Excel Worksheet Functions | |||
two dimensional arrays | Excel Worksheet Functions | |||
Multi-dimensional arrays | Excel Programming | |||
Declaring 2 dimensional arrays | Excel Programming |