View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Greg Wilson[_4_] Greg Wilson[_4_] is offline
external usenet poster
 
Posts: 218
Default Counting the number of elements within an array that have data

Try:

MsgBox Application.Count(Array)

Regards,
Greg

-----Original Message-----
I have a 1D VBA array filled with integers. I have gone

through the
array and deleted various element (i.e. array(3)

= "",array(7) = ""
etc).

I now want to count the number of elements within the

revised array
which contain integers only (or no data at all - whatever

is easier).

How do I do this?

Thanks


---
Message posted from http://www.ExcelForum.com/

.