Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi guys.
Here it is dim v as variant v = Range("a1").Value gives me ordinal type of variant v (double, string ... etc) v = Range("a1:a5").Value gives me 1-dimensional array v = Range ("a1:c1").Value gives me 2-dimensional array sub a (rng as range) v = rng.value gives me .....????? end sub questions 1. does anybody know how to always have 2-dimensional array in v= rng.value ? 2. Does anybody know how to find dimension of variant if I even don't know if it is an array 2. Does anybody know how to make 2-dim array from a number or 1-dim array? Thanks for help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
microsoft.excal 2009 | New Users to Excel | |||
range and variant | Excel Programming | |||
Disconnected Range to Variant | Excel Programming | |||
How do I assign range to variant and use | Excel Discussion (Misc queries) | |||
Excal Concatination of cells that are not empty | Excel Worksheet Functions |