Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a worksheet contains a named range referenced to cells A1:C3 called
InputRange I read this range into a variant and then want the dimensions of the variant. Sub ReadRange() Dim IRange() As Variant IRange() = Range("InputRange") End Sub I tried but I can only find the vertical dimension with the following: MsgBox UBound(IRange) Can someone help me how to find the other dimension? Thanks a lot on your ideas... Frans |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I assign range to variant and use | Excel Discussion (Misc queries) | |||
using find with variant? | Excel Programming | |||
Find Variant | Excel Programming | |||
Changing Properties of a Range object after initial Dimensions ?? | Excel Programming | |||
How to define a Range with variant? | Excel Programming |