CODEWITHSUNDEEP
vbaexcel
LoganFrederick
LoganFrederick

Reputation: 327

Syntax Error On VB Subroutine Call?

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?

Upvotes: 8

Views: 6632

Answers (1)

Kazimierz Jawor
Kazimierz Jawor

Reputation: 19067

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

Upvotes: 15

Related Questions