Symbol # after numbers

  • Thread starter Thread starter Marcus
  • Start date Start date
M

Marcus

Hi, I found a code that uses the symbol # after some numbers, what is the
function of this?

This is part of the code

If N < 2 Or beta <= 0# Or beta >= 1# Or Alpha <= 0# Or Alpha >= 1# Then
Tol2 = CDbl(CVErr(xlErrValue))
Exit Function
End If
c = 1# / Sqr(2# * 3.14159265358979)

Thanks.
 
That signifies significant digits. For example, if you type beta >= 1.00000,
VBA will automatically revice the syntax to bets >= 1#, but if you type beta
= 1, VBA leaves that syntax alone. Try it yourself. Hope this helps! If
Click to expand...
so, let me know, click "YES" below.
 
Hello,

Its just telling VBA that the constant is of type double so it does
not need to get casted (VBA will never get irritated :-)

# --> Double
% --> Integer
& --> Long
@ --> Currency
! --> Single
$ --> String

[found in the web]

Regards,
Bernd
 
Back
Top