Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
0 "0" ""
Is there any difference between:
Array(0, 0, 0) Array("0", "0","0") Array("", "","") Thanks, DL |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 * |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
correct syntax for nesting "if", "and", and "vlookup"....if possib | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |