RE: general question about variables

Giganews Newsgroups
Subject: RE: general question about variables
Posted by:  JMB
Date: Fri, 19 May 2006

Long is an integer data type

Maybe Currency, Single, or Double would work better?

Single
(single-precision floating-point) 4 bytes -3.402823E38 to -1.401298E-45 for
negative values; 1.401298E-45 to 3.402823E38 for positive values

Double
(double-precision floating-point) 8 bytes -1.79769313486231E308 to
-4.94065645841247E-324 for negative values; 4.94065645841247E-324 to
1.79769313486232E308 for positive values

Currency
(scaled integer) 8 bytes -922,337,203,685,477.5808 to
922,337,203,685,477.5807

"integreat" wrote:

>
> I can't for the life of me get this line of code to work:
>
> deltaX = .01
>
> When I go to the immediate window I find deltaX = 0
>
> I can't assign a decimal value to that variable. I remember it was much
> easier in quick basic to do this What am I doing wrong?
>
> BTW the variable deltaX has been dimensioned as LONG
>
> The good news is that I almost have a custom function that will allow
> intergration by the trapezoidal method.
>
> --
> integreat
> ------------------------------------------------------------------------
> integreat's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34282
> View this thread:http://www.excelforum.com/showthread.php?threadid=543908

Replies

None

In response to

general question about variables posted by integreat on Fri, 19 May 2006