Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting the number of elements within an array that have data
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting the number of elements within an array that have data
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting the number of elements within an array that have data
Why not count them when you change them?
-- Regards, Tom Ogilvy "ExcelMonkey " wrote in 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/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting recurring part nos. in a list
i am wondering how i can get excel to count the recurring
part numbers in a list. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting recurring part nos. in a list
Have you tried using the COUNTIF function?
Roger Shaftesbury (UK) "sheila" wrote in message ... i am wondering how i can get excel to count the recurring part numbers in a list. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maximum number of elements in array | Excel Discussion (Misc queries) | |||
Counting the Number of Elements in an Array | Excel Discussion (Misc queries) | |||
What is the maximum allowed number of data elements in a data array? | Excel Discussion (Misc queries) | |||
Counting Elements in a String | Excel Worksheet Functions | |||
counting column elements | Excel Programming |