|
- Sub 保存()
- Dim rg As Range
- On Error Resume Next
- Set rg = Application.InputBox("请选择要保存的区域", , , , , , , 8)
- If Err.Number <> 0 Then
- MsgBox "请选择要保存的区域后点击 确定 "
- Err.Clear
- Exit Sub
- End If
- rg.Copy
- Workbooks.Add
- ActiveSheet.Range("a1").PasteSpecial
- With Application.Dialogs(xlDialogSaveAs)
- If .Show Then
- MsgBox "保存完成"
- End If
- End With
- Application.CutCopyMode = False
- ActiveWorkbook.Close True
- End Sub
- 改了下。
复制代码 |
|