Correct way to call function with 2 args...

  • Thread starter Thread starter Phil_V
  • Start date Start date
P

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
 
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

Phil_V said:
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:
Click to expand...
found then it will be created with needed grid
 
Back
Top