Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
OP wrote
--How can I tell if an array declared initially as myArray() has yet been ReDim'ed? Dana DeLouis wrote: Just another idea then... Sub Demo() Dim v As Variant ' etc If Not IsArray(v) Then ReDim v(1 To 10) End Sub If it has been ReDim'ed (e.g., 1 to 5) then this code won't disclose that. Alan Beban |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamic Sum Array Formula Input Help | Excel Discussion (Misc queries) | |||
Validation list via dynamic array in VBA | Excel Discussion (Misc queries) | |||
How to declare a dynamic array | Excel Discussion (Misc queries) | |||
see if dynamic array used | Excel Programming | |||
Q: Declaring a dynamic array | Excel Programming |