Correct way to call function with 2 args...
 

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

-------------------

--
Phil_
-----------------------------------------------------------------------
Phil_V's Profile: http://www.excelforum.com/member.php...fo&userid=3185
View this thread: http://www.excelforum.com/showthread.php?threadid=52352

Correct way to call function with 2 args...
 

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" schrieb im
Newsbeitrag ...

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

--------------------


--
Phil_V
------------------------------------------------------------------------
Phil_V's Profile:
http://www.excelforum.com/member.php...o&userid=31857
View this thread: http://www.excelforum.com/showthread...hreadid=523527