Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 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 End If '. . . but can't help thinking I'm missing the forest for the trees. Thanks, Alan Beban |