I have an array defined like this
which sometimes gets filled and sometimes does not. How would I check to see if there's anything in it?Please Login or Register to view this content.
Thanks
I have an array defined like this
which sometimes gets filled and sometimes does not. How would I check to see if there's anything in it?Please Login or Register to view this content.
Thanks
You either quit or become really good at it. There are no other choices.
How are you trying to fill it? And under what circumstances would it be left empty?
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
One way :
Please Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
That's wonderful Mr. Karedog
The same approach but using UDF
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Great! Only getting back into it after being away for a while. Thank you everyone who contributed.
You're welcome. Glad we can offer some help for you
This is a trivial test:
or you can test my_array directly as follows:Please Login or Register to view this content.
Please Login or Register to view this content.
You are welcome, thanks for the rep.points.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks