excel - Syntax Error On VB Subroutine Call? -


in visual basic code behind excel spreadsheet, have 1 subroutine takes parameters. called subroutine.

here subroutine declaration:

sub rowpasting(byval oldrow integer, byval newrow integer, byval oldsheet worksheet, byval newsheet worksheet) 

here call:

rowpasting(j,k,ttworksheet,newsheet) 

all variables use inputs parameters set , valid because used working parts of program before tried add new subroutine.

any ideas on causing syntax error on call?

to call subroutine need use 1 of following syntax:

call rowpasting(j,k,ttworksheet,newsheet) 

or

rowpasting j,k,ttworksheet,newsheet 

Comments

Popular posts from this blog

linux - Does gcc have any options to add version info in ELF binary file? -

android - send complex objects as post php java -

charts - What graph/dashboard product is facebook using in Dashboard: PUE & WUE -