2,462
社区成员
发帖
与我相关
我的任务
分享
Dim dataRange As range
Set dataRange = Sheets(os).range("A1:" & s_col_end & i_row_end)
MsgBox dataRange.Rows.Count
Dim data_f_row, data_e_row As Integer
data_f_row = GetRowForCellValue("序号", dataRange)
Function GetRowForCellValue(ByVal s As String, ByVal r As range) As Integer '在这行显示错误:编译错误,对象使用无效
Dim findrange As range
If Not s = "" And Not r = Nothing Then
findrange = RngFind(s, r)
GetRowForCellValue = findrange.Row
Else
GetRowForCellValue = 0
End If
End Function
findrange = RngFind(s, r)
应该是
set findrange = RngFind(s, r)