View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Charles Williams Charles Williams is offline
external usenet poster
 
Posts: 968
Default Dim Array as Byte

The main advantage is more efficient processing of characters in strings.

Assigning a string to a byte array and then looping thru the byte array is
much more efficient than looping through the characters in the string using
MID.

regards
Charles Williams
Decision Models

"ExcelMonkey" wrote in message
...
What would be the advantage to dimensioning an array as a Byte - such as:

Arr() As Byte

Thanks

EM