| 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 *** |
| 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 | |||
Threaded Mode
