0 "0" ""
 

Is there any difference between:



Array(0, 0, 0)

Array("0", "0","0")

Array("", "","")



Thanks,

DL

0 "0" ""
 

"tegger" wrote in message
...

Is there any difference between:

Array(0, 0, 0)

An array of numerics

Array("0", "0","0")

An array of strings

Array("", "","")

An array of zero-length strings

P

0 "0" ""
 

"tegger" wrote in message
...
Is there any difference between:
Array(0, 0, 0)
Array("0", "0","0")
Array("", "","")

They all result in 3-element Variant arrays. The first array contains
the numeric value zero in each of its elements. The second array contains
the String value "0" in each of its elements. The difference between these
two is very subtle due to the fact the VBA will transparently convert
between numeric values and string values like these. The third array
contains empty strings in each of its elements.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *