Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What type of Array is this?
The following code returns *Variant()* as the Array type of Range("a1:a100"). Sub DetermineArrayType() Dim v v = Range("a1:e100").value Msgbox Typename(v) End Sub And yet the next code does not recognize the same Range as an array as an error is returned on *v = Range("a1:e100").value*. Sub DetermineArrayType2() Dim v(1 To 100, 1 to 5) v = Range("a1:e100").value Msgbox Typename(v) End Sub Any explanation? -- davidm ------------------------------------------------------------------------ davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645 View this thread: http://www.excelforum.com/showthread...hreadid=382706 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inputbox type 64 (array) | Excel Discussion (Misc queries) | |||
array values type mismatch? | Excel Programming | |||
Array Type programming | Excel Programming | |||
other type values in array. | Excel Programming | |||
other type values in array. | Excel Programming |