Invalid outside procedure Error message

[shedragon713]

Hello,
I'm trying to declare variables & constants and am getting "Invalid outside procedure" error message on "SET" no matter where I put the following:

Please Login or Register  to view this content.

What am I doing wrong? Any help is greatly appreciated.
Thank you.

[TMS]

The clue is in the message. You can't carry out commands outside a procedure ... that is, a subroutine or function.

You can define the variables as public so they can be used and shared everywhere, but you have to set the values in a subroutine. Best bet is to use the Workbook Open Event handler.

[shedragon713]

Thanks. I misread the error message -- it should say "invalid outside *of* procedure". Thanks again.

[TMS]

You're welcome. Thanks for the rep.


Not sure I see the difference that makes, if I'm honest

"Invalid outside procedure" or "Invalid outside a procedure" or "Invalid outside of procedure" or "Invalid outside of a procedure"; all much of a muchness. It is simply stating that 'the instruction is "Invalid outside procedure"'. I guess the intention is to keep the message short but maybe in this case it's "less is less" not "less is more".