test string array

[kirkm]

Dim Test() as string


How can I test "test" ? I've tried IsNull, IsEmpty, Ubound, and = Nothing but they all return an error, or False when it should be True (i e. when never used)



Thanks

 

[NauticalGent]

Can you show your code? In particular how you are populating your array?

 

[kirkm]

It's as on line 1. That's all there is. I'm trying to test it at that point.

 

[theDBguy]

Dim Test() as string


How can I test "test" ? I've tried IsNull, IsEmpty, Ubound, and = Nothing but they all return an error, or False when it should be True (i e. when never used)



Thanks

Hi. Can’t test this right now but what do you get with this?

If Not ArrayName = -1 Then

 

[kirkm]

I get a type Mismatch on the = char.

 

[kirkm]

I did find a solution
https://stackoverflow.com/questions/38784430/how-to-check-if-an-array-is-empty-in-vba


Odd that VBA doesn't something smaller/easier. Or does it ?

 

[NauticalGent]

When I use Arrays, the expected results are static. In other words I KNOW what the UBound is supposed to be and I know characteristics that each element should be i.e. length, text, number etc. It is those characteristics that I test and then react accordingly.

When I use them in a loop, I make sure to “flush” them completely ReDim() them at the start of the loop, otherwise they will hold the information from the prior round...

 

[kirkm]

I am using them in a Class module and as Set to New instance each time, I assume all will be empty.

 

[NauticalGent]

I am using them in a Class module and as Set to New instance each time, I assume all will be empty.

I would agree...

 

[MajP]

Just go here and take all the code an put in a module. I import this library into any database where I use a lot of arrrays. Invaluable!
http://www.cpearson.com/excel/VBAArrays.htm

 

[MajP]

I see that your original link already references Chip's site.

 

[theDBguy]

I did find a solution
https://stackoverflow.com/questions/38784430/how-to-check-if-an-array-is-empty-in-vba


Odd that VBA doesn't something smaller/easier. Or does it ?

Hi. Glad to hear you got it sorted out. Good luck with your project.