Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dim i,j,k As Integer
If you write:
Dim i,j,k As Integer does that mean that only one of the variables actually is declared as an Integer (i or k) and the are declared as Variant? Also is it true that Integer no longer really exists in VBA (at least v. 6.3)? I am told that an Integer is converted to a Long so it is better to use Long to begin with since the program does not have to convert the Integer to Long. Please ansewer these questions only if you are positive (I do not mean to come off as rude but I need to be sure). Thanks very much in advance! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dim i,j,k As Integer
Arne,
With this: Dim i,j,k As Integer i and j are variants, k is an integer. Use Dim i As Integer Dim j As Integer Dim k As Integer To check your last point, if this errors on the last line, then i is truly an integer Sub Test() Dim i As Integer Dim j As Long j = 654321 j = 654321 End Sub HTH, Bernie MS Excel MVP "Arne Hegefors" wrote in message ... If you write: Dim i,j,k As Integer does that mean that only one of the variables actually is declared as an Integer (i or k) and the are declared as Variant? Also is it true that Integer no longer really exists in VBA (at least v. 6.3)? I am told that an Integer is converted to a Long so it is better to use Long to begin with since the program does not have to convert the Integer to Long. Please ansewer these questions only if you are positive (I do not mean to come off as rude but I need to be sure). Thanks very much in advance! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dim i,j,k As Integer
Thanks alot for your help! Regarding the last question I had your cod edoes
not answer the question. I am told that vb automatically converts Integer to Long. Thus, any variable declared as Integer automatically transforms into Long implying that it can take any data that a variable declared as Long can do. The only difference is that the program needs to convert Integer to Long i.e. you do not notice the conversion it is just a waste of program memory capacity. If anyone knows if this is true or not please let me know! Thanks alot in advance! "Bernie Deitrick" skrev: Arne, With this: Dim i,j,k As Integer i and j are variants, k is an integer. Use Dim i As Integer Dim j As Integer Dim k As Integer To check your last point, if this errors on the last line, then i is truly an integer Sub Test() Dim i As Integer Dim j As Long j = 654321 j = 654321 End Sub HTH, Bernie MS Excel MVP "Arne Hegefors" wrote in message ... If you write: Dim i,j,k As Integer does that mean that only one of the variables actually is declared as an Integer (i or k) and the are declared as Variant? Also is it true that Integer no longer really exists in VBA (at least v. 6.3)? I am told that an Integer is converted to a Long so it is better to use Long to begin with since the program does not have to convert the Integer to Long. Please ansewer these questions only if you are positive (I do not mean to come off as rude but I need to be sure). Thanks very much in advance! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dim i,j,k As Integer
Have a read of the discussion
http://www.dailydoseofexcel.com/arch...ng-vs-integer/ Cheers Andy Arne Hegefors wrote: Thanks alot for your help! Regarding the last question I had your cod edoes not answer the question. I am told that vb automatically converts Integer to Long. Thus, any variable declared as Integer automatically transforms into Long implying that it can take any data that a variable declared as Long can do. The only difference is that the program needs to convert Integer to Long i.e. you do not notice the conversion it is just a waste of program memory capacity. If anyone knows if this is true or not please let me know! Thanks alot in advance! "Bernie Deitrick" skrev: Arne, With this: Dim i,j,k As Integer i and j are variants, k is an integer. Use Dim i As Integer Dim j As Integer Dim k As Integer To check your last point, if this errors on the last line, then i is truly an integer Sub Test() Dim i As Integer Dim j As Long j = 654321 j = 654321 End Sub HTH, Bernie MS Excel MVP "Arne Hegefors" wrote in message ... If you write: Dim i,j,k As Integer does that mean that only one of the variables actually is declared as an Integer (i or k) and the are declared as Variant? Also is it true that Integer no longer really exists in VBA (at least v. 6.3)? I am told that an Integer is converted to a Long so it is better to use Long to begin with since the program does not have to convert the Integer to Long. Please ansewer these questions only if you are positive (I do not mean to come off as rude but I need to be sure). Thanks very much in advance! -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dim i,j,k As Integer
Arne,
If, for some reason, you want to limit your values to the max range of an Integer, you are still free to use them. However, since the underlying system is 32 bit, unless you are using a very old or very new system, you may as well forego any conversion and use the "native" numeric data type. Dim i as long for i=1 to 10 ....etc NickHK "Arne Hegefors" ... Thanks alot for your help! Regarding the last question I had your cod edoes not answer the question. I am told that vb automatically converts Integer to Long. Thus, any variable declared as Integer automatically transforms into Long implying that it can take any data that a variable declared as Long can do. The only difference is that the program needs to convert Integer to Long i.e. you do not notice the conversion it is just a waste of program memory capacity. If anyone knows if this is true or not please let me know! Thanks alot in advance! "Bernie Deitrick" skrev: Arne, With this: Dim i,j,k As Integer i and j are variants, k is an integer. Use Dim i As Integer Dim j As Integer Dim k As Integer To check your last point, if this errors on the last line, then i is truly an integer Sub Test() Dim i As Integer Dim j As Long j = 654321 j = 654321 End Sub HTH, Bernie MS Excel MVP "Arne Hegefors" wrote in message ... If you write: Dim i,j,k As Integer does that mean that only one of the variables actually is declared as an Integer (i or k) and the are declared as Variant? Also is it true that Integer no longer really exists in VBA (at least v. 6.3)? I am told that an Integer is converted to a Long so it is better to use Long to begin with since the program does not have to convert the Integer to Long. Please ansewer these questions only if you are positive (I do not mean to come off as rude but I need to be sure). Thanks very much in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I add an integer to an existing integer? | Excel Worksheet Functions | |||
integer | Excel Worksheet Functions | |||
traverse until non integer | Excel Programming | |||
Get next Integer value | Excel Programming | |||
Not seeing integer | Excel Programming |