Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
optional args in UDF | Excel Programming | |||
Correct way to call active worksheet? | Excel Programming | |||
Over 29 args in a UDF with double parens | Excel Programming | |||
call a function from VBA | Excel Programming | |||
call function | Excel Programming |