excel2007 関数Functionの 引数を配列に, 戻り値を配列に指定する方法のメモです. /////////////////////////////////////////////////////////////////////////////////// '関数の定義 Function calc(ByVal tmp As Integer, Data() As Integer) As Integer()'引数に配列Data()と戻り値にInteger型の配列を利用することを宣言 ReDim tmpData(10) As Integer nodenum = 10 cachenum = 3 For xx = 0 To 9 tmpData(xx) = 0 Next xx For n = 2 To cachenum + 1 If Cells(tmp, n) <> "" Then tmpD