View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John Coleman John Coleman is offline
external usenet poster
 
Posts: 274
Default 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