Function with 2 variables

[Peter1245]

Hi,

I just got started with VBA and I think
Could you help me out with this one?

I have a function which I originally intented to have 1 varible.

Please Login or Register  to view this content.

This works perfect, but when I change one line adding a string to the function [CODE]Call func1(Row, 2)CODE] I get an error message byref argument type mismatch. In the function I have already declared that I am using 2 Integers. What can I do about this?

Cheers
Pete

[p24leclerc]

It would be interesting to see your codes for the function funcl(var1,var2) you call in this macro.

[Peter1245]

The function starts with

Please Login or Register  to view this content.

[p24leclerc]

your function define the first parameter as an INTEGER but you forgot to DIM the variable ROW which is by default a Variant. As you pass your parameter ByRef, you need to use the EXACT same data type at both place.

Add this statement in your "firstsub" procedure:

Please Login or Register  to view this content.