| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code optimization - why using long instead of integer?
Can anyone explain to me that why VBA converts all integer values to long to
make the program run faster? Mean that Integer is meaningless? "VBA converts all integer values to type Long, even if they are declared as type Integer. In fact, Long variables might be slightly faster because VBA does not have to convert them." |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel code optimization | Excel Discussion (Misc queries) | |||
| VBA Code Optimization | Excel Programming | |||
| Declaring variables (Long, String, Integer) and interpretation spe | Excel Programming | |||
| Hash a range, output a Long Integer? | Excel Programming | |||
| calculate/concert long/integer to date time | Excel Programming | |||
Threaded Mode
