Adding Second Variable to a Function

Hello All,
I'm writing a function that I can pass a name of a table and column name and it will sort the table by the desired column. I'm testing it in pieces as I go. I started by recording a macro that sorts. To test my syntax for writing a function with variables, I took the code from my recording an put it in a function, then added variables that don't do anything yet. It works fine if I only include one variable to be passed to the function, but as soon as I add a second variable to be passed to the function I get an error in the sub I'm using to test the function. The error says "Expected =". Does anyone know why this is happening?
Thanks.

Here is my code:

Please Login or Register  to view this content.

I tried a simpler example and got the same result. It still says "expected =". Does a function have to return something? Is there a limit on the number of variables that a function can have passed to it? Below are examples of my samples that work with a single variable and don't work with two variables.

This code works:

Please Login or Register  to view this content.

This code does not work:

Please Login or Register  to view this content.

Thank you

Hi,

You have (re)discovered the joys of Excel VBA syntax.

I dont' know the reason (and don't really care), but your syntax is apparently NOT allowed for functions with more than one formal parameter. IMHO you did nothing wrong, except the syntax won't work.

You seem to need either:
a. Call FunctionName, or
b. FunctionName arg1, arg2, etc.


Try the following tested and working code:

Please Login or Register  to view this content.

Lewis

Thanks! That worked.