View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JT JT is offline
external usenet poster
 
Posts: 234
Default len of item in an array

Is it possible to check the length of each item in a specific field in an
array? Is so, how?

I am building an array but I want to check the length of a specific field
for each item in the array. For example, each "record" in my array has 4
fields. I want to check the length of the first field in each "record". If
it is greater than 0, I will do one action and if it is zero I will do
another action.

I'm using this in an edit to be verify the user has not selected a record
where the first field is blank.

Thanks for the help.

--
JT