Sub or Function not defined

[excelos]

Hello

I get so frequently the error:
Sub or Function not defined

even for very simple things like one line functions:
Sub something()
Worksheet.Activate(...)
End Sub

Any idea?
Searching online did not give valuable hints and there seem to be several causes.

Thanks!

 

[mohadin]

EX

Sub something()
Worksheets("calc").Activate
End Sub

 

[excelos]

Mmm thanks so this error is when something (that can be anything):

• needs a specific input that is missing?
• is not typed with the correct keyword to be recognised as internal VBA reserved keyword?

Because the error msg is kind of confusing by saying 'sub or function not defined' and it yellows the Sub... line instead of the Worksheets... line.

 

[Joe4]

I would like to see an actual example of code that returns this error for you, so we can better evaluate it.

Another source of issue could be typos (so maybe you are trying to use a keyword that is misspelled, so Excel thinks you are trying to call a Sub Procedure or Function).

I would highly recommend turning "Option Explicit" on, if you haven't already.
This forces you to declare all variables before using them, and helps greatly in error debugging.
If you have issues with typos, this will help catch those.
See: Option Explicit in Excel VBA