When I have my workbook activate/deactivate events, it breaks my macro:
Doesn't allow the copied range to carry over:
Anyone know the best way to do this?
Code:
Private Sub Workbook_Deactivate()
Application.DisplayFormulaBar = True
Application.DisplayFormulaBar = True
Application.DisplayStatusBar = True
Application.Caption = "Microsoft Excel"
End Sub
Doesn't allow the copied range to carry over:
Code:
...
Selection.Copy
Windows(destinTXT).Activate
Range("A1").Select
ActiveSheet.Paste
Anyone know the best way to do this?