Argument Not Optional

[mccrimmon]

Hi

I am wondering if anyone can help.
I have the following code (this is amended from someone elses code that has now left the company, however, I cannot see where it is going wrong)

All the variables are set as Private Const at the start of the module.

When trying to step through I am getting an Argument Not Optional error.

Can anyone spot if theres anything obvious mistake in the code from just looking at the below? It is erroring on the top line of the Call AddJournalLine line.

Cheers

McC

Please Login or Register  to view this content.

[incjourn]

The first thing I would chek is whether the number of vairables in the Call statement is different from the number of variables in the macro being called. I.e.
Call Macro(A,B,C)
Macro(A,B,C,D)
wouldn't work unless delacred as Macro(A,B,C,Optional D)

[shg]

Don't let that person come back ...

Please Login or Register  to view this content.

[mccrimmon]

The first thing I would chek is whether the number of vairables in the Call statement is different from the number of variables in the macro being called. I.e.
Call Macro(A,B,C)
Macro(A,B,C,D)
wouldn't work unless delacred as Macro(A,B,C,Optional D)

They always say two sets of eyes are better than one.
Had additional commas within the code.

Cheers for posting.

[royUK]

There does appear to be more arguments than required, e.g

Please Login or Register  to view this content.

Check this

Please Login or Register  to view this content.