|
- Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
- Dim r&, rng As Range
- Application.ScreenUpdating = False
- r = Application.WorksheetFunction.Max(Target.Row + 1 - 30, 1)
- Set rng = Cells(r, 1).Resize(Target.Row - r + 1, 7)
- On Error Resume Next
- Set sht = Worksheets(Target.Value): sht.Cells.Clear
- If Err.Number <> 0 Then
- Worksheets.Add.Name = Target.Value
- ActiveSheet.Move after:=Worksheets(Sheets.Count)
- Err.Clear
- End If
- rng.Copy Worksheets(Target.Value).[a1]
- Application.ScreenUpdating = True
- End Sub
复制代码 鼠标右键单击事件 |
|