Function fff(a As Range) As Integer
a_column = a.Column ’取列号
With a
myrange = Range(.Cells(1, a_column), .Cells(6, a_column)) ’ 定义a的前6行,作为range
End With
fff = Application.WorksheetFunction.Max(myrange)
End Function