View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Neal Zimm Neal Zimm is offline
external usenet poster
 
Posts: 345
Default Modern day considerations, Integer versus Long

thanks much peter.
--
Neal Z


"Peter T" wrote:

In 32 bit machines generally there's no advantage to using As Integer. If
anything there's an extra overhead involved as behind the scenes it gets
converted to a Long for storage, then back to an Integer again for use.

There are some built-in Event stubs which expect Integer arguments. You can
still pass your as Long variable though the value must not exceed +/-32k, it
might be worth declaring your variable As Integer to will help flag any
errors. There are one or two API's that expect an Integer value or variable.

Regards,
Peter T

"Neal Zimm" wrote in message
...
Hi All,
I come from a day when storage was a LOT dearer than it is today.

I use Integer or Long for whole # values 'cuz I read once that Integer
takes less memory. It's also kind of self documenting about the size of
the
#.

With memory gigs now about the size of a thumbnail, what are the major
pro's and cons of still using As Integer versus As Long.

Thanks.
--
Neal Z



.