I have developed (with a lot if help from the Forum) a macro that runs when a particular sheet in the workbook is deactivated. It appears that this is causing a general problem in the workbook where we cannot copy data from one worksheet to another, presumably because the clipboard is being emptied.
If this this a general problem that is encountered often, please let me know what if there is a way to prevent this from occuring.
Addendum to prior post:
Further to my original post, the problem is only when trying to copy to or from the worksheet with the following code:
Private Sub Worksheet_Deactivate()
Worksheets("Copy").Range("Copy_Range").Copy _
Range("Formula_Range")
Application.CutCopyMode = False
End Sub
I have seen references to this problem that suggest that to avoid the worksheet code altering the clipboard, another sub can be called that copies the data without using the clipboard.
This problem is causing a lot of frustration as the worksheet with the code is used quite a bit and we need to be avle to copy text from this worksheet to other sheets in the workbook.
Any suggestions would be greatly appreciated.
Thanks again.
Regards,
Craig
Bookmarks