excel 宏之查找

Function findstr(strfind, myrow As Integer, mycolumn As Integer) As String
    Dim activeRow, activeColumn, returnRow, returnColumn As Integer
    Windows(fledate & ".txt").Activate
    Range("A1").Select
    Cells.find(What:=strfind, After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
        xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False) _
        .Activate
    activeRow = ActiveCell.Row
    returnRow = activeRow + myrow     '''''''''''查找对应行
   
    activeColumn = ActiveCell.Column
    returnColumn = activeColumn + mycolumn  '''''''''''查找对应列
   
   
   
    findstr = Worksheets(1).Cells(returnRow, returnColumn).Value
    Workbooks("cmsc基本指标.xls").Worksheets(2).Activate  '''''激活报表窗口
End Function

发表于 2005-02-07 14:54

评论

# 回复: excel 宏之查找 2006-01-30 20:48:00 blizz

如果找不到呢,怎么判断?

发表评论

标题:  
署名:  
链接:
内容:
验证码: