prabhafriend
11-23-2010, 05:55 AM
fieldnames = Array(Array("Account Class", "LE", "Acc-Pro", "BU", "DS", "CCY", "Value"), Array("Account Class", "Legal Entity", "Account", "Business Unit", "Data Source", "CCY", "Balance (USD)"), , Array("Account Type", "Legal Entity", "Account", "Product", "Business Unit", "Data Source", "Transaction Currency", "USD Equiv - Prior Period"), Array(, , "+-", "=Right((), 6)", , "=Left((),3)"))
i=0
Call Locate_Matrix(files(i), fieldnames(i+1))
Function Locate_Matrix(ByVal bookname As String, fieldlist() As Variant) As Boolean
Why I am getting an Type mismatch saying "Array or User-defined type expected" Highlighting the fieldnames(i+1). At the same time Isarray(fieldnames(i+1)) returns true. How come?
i=0
Call Locate_Matrix(files(i), fieldnames(i+1))
Function Locate_Matrix(ByVal bookname As String, fieldlist() As Variant) As Boolean
Why I am getting an Type mismatch saying "Array or User-defined type expected" Highlighting the fieldnames(i+1). At the same time Isarray(fieldnames(i+1)) returns true. How come?