Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Row > 2 And Cells(Target.Row, 2) <> "" Then
'If Target.Row > 2 And Cells(Target.Row, 2) <> "" And Target.Column = 2 Then
Sheets("档案表打印").Range("d4") = Cells(Target.Row, 2)
Sheets("档案表打印").Select
End If
End Sub
這一個可以,共他好像有問題