Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Iteration
A repost that might clarify what's going on:
Is there a standard way of handling something like the following? Function DeleteColumn(inputArray, ColumnNumber) If IsArray(ColumnNumber) Then [Run the DeleteColumn function itself] [on each column number in turn] inputArray = arrOut DeleteColumn = arrOut Exit Function Else [code to create an array of the input] [array less the single column number,] [assigned to the variable arrOut] inputArray = arrOut DeleteColumn = arrOut End If End Function I ended up creating a DeleteColumnAdjunct function that is the same as the DeleteColumn function except for name, and ran Function DeleteColumn(inputArray, ColumnNumber) If IsArray(ColumnNumber) Then For w = UBound(ColumnNumber) To _ LBound(ColumnNumber) Step -1 arrOut = DeleteColumnAdjunct(inputArray, ColumnNumber(w)) Next inputArray = arrOut DeleteColumn = arrOut Exit Function Else [code to create an array of the input] [array less the single column number,] [assigned to the variable arrOut] inputArray = arrOut DeleteColumn = arrOut End If End Function It works, but I can't help thinking I'm missing the forest for the trees. Thanks, Alan Beban |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Iteration | Excel Worksheet Functions | |||
iteration | Excel Discussion (Misc queries) | |||
Need help with iteration | Excel Discussion (Misc queries) | |||
Iteration | Excel Discussion (Misc queries) | |||
Iteration | Excel Discussion (Misc queries) |