In the bad old days, I only used constants as a way to assign names to values. Things like this, for example: Private Const DaysInWeek As Integer = 7 However, these days most of my variables are ...

Here, max is not local to function foo. It's effectively global. You can't declare a macro as a member of a C++ class or namespace. In a sense, macro names are more pervasive (read “worse”) than ...