• VBA表格单元格替换文字


    Sub 表格单元格替换文字()
       If MsgBox("确定要替换单元格的文字吗?", vbYesNo + vbQuestion) = vbYes Then
        For i = 1 To ActiveDocument.Tables.Count
            With ActiveDocument.Tables(i).Cell(Row:=2, Column:=2).Range
                .Delete
                .InsertAfter Text:="XXX"
            End With
    
    
    With ActiveDocument.Tables(i).Cell(Row:=13, Column:=2).Range
                .Delete
                .InsertAfter Text:="与预期结果一致"
            End With
    
    With ActiveDocument.Tables(i).Cell(Row:=14, Column:=2).Range
                .Delete
                .InsertAfter Text:="通过"
            End With
    
     With ActiveDocument.Tables(i).Cell(Row:=15, Column:=2).Range
                .Delete
                .InsertAfter Text:=""
            End With
    
     With ActiveDocument.Tables(i).Cell(Row:=16, Column:=2).Range
                .Delete
                .InsertAfter Text:="XXX"
            End With
    
    
     With ActiveDocument.Tables(i).Cell(Row:=17, Column:=4).Range
                .Delete
                .InsertAfter Text:="2014-11-20"
            End With
    
        Next
            MsgBox ("操作完成!")
        Else
            MsgBox ("操作取消!")
        End If
    End Sub
  • 相关阅读:
    angular 复选框回选
    $parse
    AngularJS 指令的 Scope (作用域)
    文献解读 (1)
    献给初学者:常用的细胞凋亡检测方法
    KofamKOALA
    Dfam.h5.gz下载
    Augustus-3.3.3安装
    bamtools 2.5.1安装
    R语言从原点开始作图
  • 原文地址:https://www.cnblogs.com/zjwia/p/5403452.html
Copyright © 2020-2023  润新知