Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi there,
I define a dynamic array as Dim myDyn() as Variant Is there any way to redim its element type as String? The reason that I need to do this is because when I pass myDyn(1) to a function whose parameter is String, it reports "ByRef argument type mismatch". I am wondering if this is the reason. Any other suggestion to avoid this bug report? Thank, lvcha |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ReDim Object array as parameter of Variant array | Excel Programming | |||
Type mismatch accessing variant array too many times | Excel Programming | |||
Variant type for Excel cell percentage data format | Excel Programming | |||
Variant Array with String Values - Type Mismatch | Excel Programming | |||
How to check a Variant for its data type | Excel Programming |