Calling Functions
On Nov 9, 6:10 am, David 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
|