Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
testing if an array is initialized 1
- Thread starter fenris
- Start date
-
1
- #2
JohnYingling
Programmer
If IsArray(array) then
- Thread starter
- #3
JohnYingling
Programmer
It depends on how it is defined. You may have to use On error
Code:
Dim v() As Integer
Dim blnInit as boolean
If IsArray(v) Then
blnInit = True
On Error resume next
' fails with subscript out of range
Debug.Print UBound(v)
if Err.Number <> 0 then blnInit = false
On error goto 0
End If
Dim v As Variant
If IsArray(v) Then ' Is not an array Ok.
debug.Print UBound(v)
End If- Status
Similar threads
- Question
- Locked
- Question