I've got a Module like this:

Public Sub Overpayments()

code

End Sub

When I try to call this Sub using:

Call Overpayments

I get an error "Compile Error: Expected variable or procedure, not
module"

What did I do wrong and how can I fix it? Sorry if this is a very
basic question.

Thanks!

On Nov 9, 6:10 am, David <skulkrinb...@googlemail.com> wrote:
> I've got a Module like this:
>
> Public Sub Overpayments()
>
> code
>
> End Sub
>
> When I try to call this Sub using:
>
> Call Overpayments
>
> I get an error "Compile Error: Expected variable or procedure, not
> module"
>
> What did I do wrong and how can I fix it? Sorry if this is a very
> basic question.
>
> Thanks!

My guess is that you have both a module and a sub called Overpayments,
so VBA is unhappy with the name clash. If so, try renaming the
moduleModOverpayments

hth

-John Coleman

Thanks you're right. I've been scratching my head over that one for a
few minutes.