There isn't really any advantage unless it is required by the
procedure to which you are passing it. As a general coding practice,
it is best to use Longs or Doubles for numeric variables. Forget about
Integers and Singles. A typical computer today has memory to spare and
the savings gained by using Bytes, Integers, or Singles are miniscule.
If you are that concerned about memory usage, you shouldn't be using
VBA in the first place.


Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Fri, 29 May 2009 13:01:01 -0700, ExcelMonkey
wrote:

What would be the advantage to dimensioning an array as a Byte - such as:

Arr() As Byte

Thanks

EM