Calling a sub from another sub - passing variables

[vbacoder]

Hi everyone,

I am having problems with the syntax involved in calling one subroutine from within another. I want to pass two variables calculated in a 'main' sub into the parentheses of another I am calling (see pseudocode below). When I pass one variable, everything works fine, however, when I try to include another, I get an error message - something about expecting an "=" in the syntax, which is clearly not correct.

Sub main()

row = .....

column = .....

counting(row, column)

End sub()


Sub counting (row, column)

.....


End sub

Many thanks,

vcoder

 

[vbacoder]

I always use the Call mysub(x,y,...) syntax and - yes - I was brought up on Fortran in the last century.

I am always itching to use FTN syntax; usually to no avail in most 'contemporary' languages.