VBA 获得绝对地址控制焦点的设置

先上代码,有时间再补上说明。

Dim Mefoucs As String

MsgBox "你选定的当前单元格是:" & Selection.Address
Mefoucs = Selection.Address
'ActiveCell.Column
    Range(Mefoucs).Select
    Selection.Copy
    Range("G17").Select
    ActiveSheet.Paste
    Application.CutCopyMode = False
      Range(Mefoucs).Select

  

posted on 2017-02-08 14:07  手撕高达的村长  阅读(999)  评论(0编辑  收藏  举报

导航