Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Clearing Contents | Excel Discussion (Misc queries) | |||
Clearing contents not formatting | Excel Discussion (Misc queries) | |||
clearing the contents of specified cells | Excel Programming | |||
Clearing Contents | Excel Programming | |||
Clearing Contents but not Formulas | Excel Worksheet Functions |