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?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[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

"Phil_V" <[email protected]> schrieb im
Newsbeitrag news:[email protected]...
>
> 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
>