Explanation of use of the character " # "

[DouCow]

Can someone tell me what the function is for the " # " sign at the end of a number - such as in:

Const dia As Double = 150#
Const ctrX As Double = 200#
Const ctrY As Double = 100#

Could not find anything on the web other than as an ASCII character definition.

[MarvinP]

Hey DouCow,

Look on https://excelmacromastery.com/vba-dim/ down in the Replies.
"There are only a few possible suffixes" for Dim Type
# = Double, % = Integer, & = Long, ! = Single, $ = String

Some VBA code writers like to use

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

I hate this type of short Dim statement as it makes me stop and look up what the #%$& stuff means. Learn to write better VBA and make your variables meaningful. Instead of i, j, k; name them LastRow, RowCtr, ColCtr. That way reading the code is much easier.

While I'm on this rant....
We have a few Gurus on this site who want to write as few lines of code as possible. I've struggled understanding their code just because they don't Dim their variables with real words. Then when I ask WTF their code is doing they say it works and that is enough. If we are here to help explain answers to problems, I'd like to see readable VBA code. End Rant

[MarvinP]

Now that I'm over my rant... I think the "#" at the end of the lines doesn't make sense. I wonder if it works?
Read: https://docs.microsoft.com/en-us/dot...are-a-constant

[MarvinP]

I also see a method to see which type of Dim declaration wins. With something like:

Please Login or Register  to view this content.

Will bob be a double or single (!)?
This line of code will show which type bob really is:

Please Login or Register  to view this content.

which returns a "DOUBLE"
Read this site:
http://www.learnexcelmacro.com/wp/20...in-a-variable/

[Rick Rothstein]

I think the "#" at the end of the lines doesn't make sense. I wonder if it works?

It will work, but it won't matter for whole numbers if you include it or not (actually, in most cases it will not matter, but you do have to be careful). What that symbol does is convert the number to the data type indicated by the symbol before making the assignment. Here is an example where it would matter...

Const X As Double = 12.123456!
MsgBox.Print X

The VBA processor will change the 12.123456! to 12.12346! in order to make it fit into a Single data type (you are seeing the rounded value for a Single data type, but there are some "guard digits" that are unseen to help keep calculations somewhat "exact"). If you run the code, the MessageBox will display 12.1234560012817 instead of the 123456 that was originally intended because that is what that Single value becomes when promoted to a Double.