ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   any variable size (https://www.excelbanter.com/excel-programming/344872-any-variable-size.html)

x taol

any variable size
 


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 ***

Rowan Drummond[_3_]

any variable size
 
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 ***



All times are GMT +1. The time now is 03:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com