# Counting the number of elements within an array that have data

Discussion in 'Microsoft Excel Programming' started by ExcelMonkey, May 17, 2004.

1. ### ExcelMonkeyGuest

I have a 1D VBA array filled with integers. I have gone through th
array and deleted various element (i.e. array(3) = "",array(7) = "
etc).

I now want to count the number of elements within the revised arra
which contain integers only (or no data at all - whatever is easier).

How do I do this?

Thank

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

ExcelMonkey, May 17, 2004

2. ### Greg WilsonGuest

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/
>
>.
>

Greg Wilson, May 17, 2004

3. ### GuestGuest

If you use the code i gave you to transfer the Elements to a New array all you have to do is use UBound(Myarray) to get the upper number and then based on your Option base: 0 = Num -1 OR 1 = Nu

But if you just want to count then here

Dim i as single, j as singl
For i = LBound(YourArray) To UBound(YourArray
if Not MyArray(i) = "" then j =j+
Next
Debug.print "Total number of elements with a value = " &
Debug.Print "Total number of elements with No Value = " UBound(YourArray) -

----- ExcelMonkey > wrote: ----

I have a 1D VBA array filled with integers. I have gone through th
array and deleted various element (i.e. array(3) = "",array(7) = "
etc)

I now want to count the number of elements within the revised arra
which contain integers only (or no data at all - whatever is easier)

How do I do this

Thank

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

Guest, May 17, 2004
4. ### Tom OgilvyGuest

Why not count them when you change them?

--
Regards,
Tom Ogilvy

"ExcelMonkey >" <<> wrote in message
news:...
> 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/
>

Tom Ogilvy, May 17, 2004
5. ### sheilaGuest

counting recurring part nos. in a list

i am wondering how i can get excel to count the recurring
part numbers in a list.

sheila, May 26, 2004
6. ### Roger WhiteheadGuest

Re: counting recurring part nos. in a list

Have you tried using the COUNTIF function?

Roger
Shaftesbury (UK)

"sheila" <> wrote in message
news:1a2901c4433a\$5f6fc0a0\$...
> i am wondering how i can get excel to count the recurring
> part numbers in a list.

Roger Whitehead, May 26, 2004

## Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.