Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() dim iLng as integer ~~~~~~~~~ then i want to know size of "iLng" using VBA. surely answer is 32767 *** Sent via Developersdex http://www.developersdex.com *** |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
It depends what you mean by size.
So far all you have done is declare the variable which has created a named storage location in memory. As you have declared it an integer the "size" of this location is 2 bytes and the range of values you could assign to the variable is -32,768 to 32,767. As you have not assinged any value to the variable it's default value is 0. Hope this helps Rowan x taol wrote: dim iLng as integer ~~~~~~~~~ then i want to know size of "iLng" using VBA. surely answer is 32767 *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Variable screen size, not resolution | Excel Worksheet Functions | |||
Variable size of chart | Charts and Charting in Excel | |||
set header font size using a variable? | Excel Programming | |||
Define an array with variable size | Excel Programming | |||
How to find out the size of a variable-size array ? | Excel Programming |