Correct way to call function with 2 args...

[Phil_V]

ARGH!!!

Why does the following function call not work?
VBA keeps telling me that an "=" is expected?


Code
-------------------
Dim Ore_Name As String
Dim ws_index As Integer

Ore_Name = "Carbon"
ws_index = 3

Find_Ore_And_Setup_Grid(Ore_Name, ws_index) ' <=== This line will NOT compil
-------------------



Code
-------------------
Function Find_Ore_And_Setup_Grid(o_name As String, ws_index As Integer)
' Will search the indexed ws of the GPI_wb for the Ore name, if not found then it will be created with needed grid


End Function

 

[Jörg]

Hi Phil,

i think there´s missin a "call" like this:

Call Find_Ore_And_Setup_Grid(Ore_Name, ws_index)

If you add the "Call" i think it will work

Best regards
Jörg

ARGH!!!

Why does the following function call not work?
VBA keeps telling me that an "=" is expected?


Code:
--------------------
Dim Ore_Name As String
Dim ws_index As Integer

Ore_Name = "Carbon"
ws_index = 3

Find_Ore_And_Setup_Grid(Ore_Name, ws_index) ' <=== This line will NOT compile
--------------------



Code:

found then it will be created with needed grid