如何用VBA语言写RANK函数 如下所示,编辑出现“运行时错误 1004 应用程序定义或者对象定义错误”大侠救我 Private Sub KILLONE() Dim i As Integer i = Application.WorksheetFunction.Rank(A1, Range(Cells(1, 1), Cells(1, 10)), 0) End Sub 以上语句具体应该怎么写
解决了,代码如下: Private Sub KILLONE() Dim i As Integer Dim Number As Double Number = Worksheets("sheet1").Cells(1, 1).Value Set myRange = Worksheets("Sheet1").Range("A1:C10")
i = Application.WorksheetFunction.Rank(Number, myRange, 0) End Sub