0 "0" ""

  • Thread starter Thread starter tegger
  • Start date Start date
T

tegger

Is there any difference between:



Array(0, 0, 0)

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

Array("", "","")



Thanks,

DL
 
tegger said:
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 *
 
Back
Top