Home > Software engineering >  How to use the macro Execl operation, the first in a table in the Execl batch link to other tables i
How to use the macro Execl operation, the first in a table in the Execl batch link to other tables i

Time:10-01

CodePudding user response:

To record a macro, you see is what to do,
Or in the cell. The formula="=the Hyperlink (...

CodePudding user response:

 Option Explicit 
Private Sub Worksheet_SelectionChange (ByVal Target As Range)
On the Error Resume Next
If the Target. The Column=1 Then
If the Target & lt;> "" Then
Worksheets (Target) Value). Activate
End the If
End the If
On Error GoTo 0
End Sub


  •  Tags:  
  • VBA
  • Related