Pat_The_Bat
Board Regular
- Joined
- Jul 12, 2018
- Messages
- 82
I have a form that users fill out, and at the bottom of the form I've added a button for the user to copy the data to be able to paste into another application we use.
Right now, the button works but it leaves the marching ants on the page.
If I use application.cutcopymode=false, it gets rid of the marching ants BUT IT ALSO Clears the cache and when I go to paste in the other application, there is nothing on the clipboard.
Any suggestions?
Right now, the button works but it leaves the marching ants on the page.
If I use application.cutcopymode=false, it gets rid of the marching ants BUT IT ALSO Clears the cache and when I go to paste in the other application, there is nothing on the clipboard.
Any suggestions?
VBA Code:
Range("D32:F58").Select
Selection.Copy