Hi guys & girls!
I have a worksheet that people use all the time to paste lots of information into.
The most time-consuming part is when you click, hold and scroll down to highlight everything that you want to copy, the data is similar to what you'd find in https://xdcc.horriblesubs.info/.
If you use Crtl-A then copy, it cause problems when you paste because of all the extra stuff that gets in the sheet.
While wondering if it is possible to make this quicker using Ctrl-A then on excel then Paste Special to Text, i experimented with:
Then i'd shortcut the macro with Ctrl-v.Please Login or Register to view this content.
This works, but it causes issues because this effects all the other sheets in the workbook and it also activates on other open workbooks.
How can i make this work for only 1 sheet called "Dump"?
Or, is there another code i can use on that specific sheet that would automatically "paste as text" whenever someone does Ctrl-v?
Thanks!!
Bookmarks