Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim hh As Single
Dim lh As Single
hh = Target.Row
lh = Target.Column
If lh = 2 Or lh = 8 Then
ActiveCell.Value = ActiveSheet.Cells(hh - 1, lh)
End If
End Sub
如果问题得以解决,请设置最佳!!!