Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Test if array empty

Posted on 2013-10-31
1
Medium Priority
?
408 Views
Last Modified: 2013-10-31
what's the best way to test if an array in VBA is empty?
0
Comment
Question by:patriotpacer
1 Comment
 
LVL 49

Accepted Solution

by:
Dale Fye earned 2000 total points
ID: 39614839
if your array name is arrMyArray, then

if UBound(arrMyArray) = -1 then
    msgbox "array is empty"
Else
     msgbox "array is not empty"
endif
0

Featured Post

[Webinar] Cloud Security

In this webinar you will learn:

-Why existing firewall and DMZ architectures are not suited for securing cloud applications
-How to make your enterprise “Cloud Ready”, and fix your aging DMZ architecture
-How to transform your enterprise and become a Cloud Enabler

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question