Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing a string aray as an argument to a function ?....Help!
I am trying to pass a string array as an argument for a function, but I keep
getting this compile error, Type mismatch: array or user-defined type expected Here is my code, why won't this work ? Option Explicit Option Base 1 Dim Oil(18), Gas(18), HO(18) As String Sub SetChrtPosAndColor() GetChartNumsFromTxtFile WriteChartNums2txtFile Oil End Sub Function GetChartNumsFromTxtFile() Dim X As Integer Open "C:\ChrtNumLst.txt" For Input As #1 For X = 1 To 54 If X < 19 Then Line Input #1, Oil(X) ElseIf X 18 And X < 37 Then Line Input #1, Gas(X - 18) ElseIf X 36 Then Line Input #1, HO(X - 36) End If Next X Close #1 End Function Function WriteChartNums2txtFile(Commodity() As String) Dim X As Integer Open "C:\WriteChtNum.txt" For Output As #1 For X = 1 To 18 Print #1, Commodity(X) Next X Close #1 End Function Dan Thompson. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
Passing range as an argument in a function | Excel Programming | |||
VBA - Passing a FUNCTION as an Argument | Excel Programming | |||
Passing an Array of User-Defined Type to an Argument of a Function | Excel Programming | |||
passing a variable as an argument to a function | Excel Programming |