Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to check the array have value
Sub xx()
Dim an_x() As Long k = 0 For i = 1 To 3 If k = 1 Then ReDim Preserve an_x(1 To i) an_x(i) = i + 6 End If Next 'check whether an_x is empty or not empty. 'how can i know that the array is emptyed. ubound or isarray or isempty or ismissing.... no ,no,no ??? End Sub *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to check the array have value
Hi X Taol,
Try: '=========== Sub xx() Dim an_x() As Long Dim k As Long, i As Long Dim v As Variant k = 0 For i = 1 To 3 If k = 1 Then ReDim Preserve an_x(1 To i) an_x(i) = i + 6 End If Next On Error Resume Next v = UBound(an_x) On Error GoTo 0 If IsEmpty(v) Then MsgBox "an_x is empty" End Sub '<<=========== --- Regards, Norman "x taol" wrote in message ... Sub xx() Dim an_x() As Long k = 0 For i = 1 To 3 If k = 1 Then ReDim Preserve an_x(1 To i) an_x(i) = i + 6 End If Next 'check whether an_x is empty or not empty. 'how can i know that the array is emptyed. ubound or isarray or isempty or ismissing.... no ,no,no ??? End Sub *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I check if known number is in array | Excel Discussion (Misc queries) | |||
check value with array, Application.Match | Excel Programming | |||
Array Check | Excel Programming | |||
Check if first character of string is in array | Excel Programming | |||
Check if a String is inside an Array | Excel Programming |