Как выделить ячейку неактивного рабочего листа, без использования методов .Select или .Activate
Категория: Basic
2012-12-09 21:11:15
code: #vba
Application.Goto Reference:=Worksheets(3).Range("A1")
code: #vba
Application.Goto Reference:=Worksheets("Manager").Range("A1")
code: #vba
Application.Goto Reference:=Worksheets(3).Range("A1:C10") Application.Goto Reference:=Worksheets(3).Range("A1,C3,D5:F10")
code: #vba
Application.Goto Reference:=Worksheets("Manager").Range("A1:C10") Application.Goto Reference:=Worksheets("Manager").Range("A1,C3,D5:F10")
code: #vba
Application.Goto _ Reference:=Workbooks("Report.xls").Worksheets("Sales").Range("M13")
code: #vba
Application.Goto _ Reference:=Workbooks("Report.xls").Worksheets(1).Range("M13")
code: #vba
Application.Goto _ Reference:=Workbooks(2).Worksheets("Sales").Range("M13")
code: #vba
Application.Goto _ Reference:=Workbooks(2).Worksheets(1).Range("M13")
code: #vba
Application.Goto Reference:=Range("Дата") Application.Goto "Дата" Application.Goto [Дата] Application.Goto Reference:="Дата" Application.Goto Reference:=[Дата]
code: #vba
Application.Goto _ Reference:=Worksheets(3).Range("Дата") Application.Goto _ Reference:=Worksheets("Manager").Range("Дата") Application.Goto Reference:=Range("Manager!Дата") Application.Goto [Manager!Дата] Application.Goto Reference:="Manager!Дата"
code: #vba
With Application If IsArray(.PreviousSelections) = True Then For Each iSelection In .PreviousSelections MsgBox iSelection.Address(External:=True) Next End If End With
Поделиться: