Public Const C_ERR_NO_ERROR = 0&
What is the & for?
Thank you
Public Const C_ERR_NO_ERROR = 0&
What is the & for?
Thank you
See https://stackoverflow.com/questions/...le-name-in-vba
What are possible suffixes after variable name in VBA?
Here is snip:
Dim A!, B@, C#, D$, E%, F&
Debug.Print "A! - " & TypeName(A)
Debug.Print "B@ - " & TypeName(B)
Debug.Print "C# - " & TypeName(C)
Debug.Print "D$ - " & TypeName(D)
Debug.Print "E% - " & TypeName(E)
Debug.Print "F& - " & TypeName(F)
Outputs
A! - Single
B@ - Currency
C# - Double
D$ - String
E% - Integer
F& - Long
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
The & is short hand for declaring a variable of type Long.
If posting code please use code tags, see here.
Note that, if you read that thread, their use is not recommended
Thanks all. xoxox
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks