View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Mark is offline
external usenet poster
 
Posts: 989
Default clearing array contents

Hello.

I am working with an array to aid in summing the cost of a bill of materials
structure.

The array has an element for each level of the bill of materials, say level
1 to level 8. (sometimes higher, program defins it based on min and max found
in the level structure)

There are times in the summing process when I need to clear out part of the
array contents, say from level 5 to level 8. I can do that by using a
counter and a for loop, and clearing each one.

My question is, is there a one program line method to clear a group of the
array elements, something that would assign levArray(lev5, lev6, lev7, lev8)
all to 0 in one step?

Thanks.
Mark