Syntax Error On VB Subroutine Call?

Question

In my Visual Basic code behind an Excel spreadsheet, I have one subroutine which takes parameters. This is called from another subroutine.

Here is the subroutine declaration:

Sub rowPasting(ByVal oldRow As Integer, ByVal newRow As Integer, ByVal oldSheet As Worksheet, ByVal newSheet As Worksheet)

Here is the call:

rowPasting(j,k,TTWorksheet,newSheet)

All the variables I use as inputs for the parameters are set and valid because they were used for working parts of the program before I tried to add this new Subroutine.

Any ideas on what is causing the syntax error on the call?

Duplicate of VBA returning error when calling a Sub with multiple parameters — brettdj
– brettdj, Commented May 3, 2013 at 10:25

Kazimierz Jawor · Accepted Answer · 2013-05-02 22:20:47Z

15

To call your subroutine you need to use one of the following syntax:

Call rowPasting(j,k,TTWorksheet,newSheet)

or

rowPasting j,k,TTWorksheet,newSheet

answered May 2, 2013 at 22:20

Kazimierz Jawor

19.1k7 gold badges38 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Damn Over a year ago

OMG! I must've lost a day rewriting the sub to fix this 'syntax error'... thanks for the fix.

Collectives™ on Stack Overflow

Syntax Error On VB Subroutine Call?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related