Can Const be defined once in one Sub in the same Module1? For example, instead of defining the same Const Count below, I just want to define it once and use it for both subs. I tried Public Const but gave error: Invalid attribute for sub or function.


Sub Test()
Const COUNT = 10
End Sub

Sub Test2()
Const COUNT = 10
End Sub
Thanks for help.