Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi.
Pretend I have an integer array variable that I'm using for somthing, arIntArray() There's a loop that goes through and populates the elements of that array, which are a subset of the columns in the spreadsheet. If it turns out that there aren't any columns which meet the condition which populates the array, is there a quick way to determine that the array is still empty? Ubound(arIntArray) fails, becuase it's undefined. Is Nothing and Null also produced errors. If needed, I can put in a Boolean flag to set if the array gets populated, but it seems like there is likely another way. Thanks. Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If Range Variable isn't Empty | Excel Programming | |||
Empty Array | Excel Programming | |||
empty variable range | Excel Discussion (Misc queries) | |||
Is the array empty? | Excel Programming | |||
Problem trying to us a range variable as an array variable | Excel Programming |