View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey[_125_] ExcelMonkey[_125_] is offline
external usenet poster
 
Posts: 1
Default 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