June 15, 2022
HI. When I used to use Google Chrome I could drag data straight from the browser and into my Spreadsheet
Since my company now insist on using the painfully slow MS Edge, when I drag data into my Spreadsheet it takes an absolute age to resolve all the properties and paste the text
Since this is core to my job, its now taking 5-6 times longer to do my job
I dont need the text properties, in fact I have to spend time removing the web page properties from the data
Is it possible to trap data being drag/dropped into XL to Paste just the values??
Regular Right Click Copy/Paste Special is farrrrrrrrrr to slow for my job. It has to be drag drop
November 8, 2013
I'm afraid it's not possible, there is a sheet Change event but this event detects any change, it cannot make the difference between a manual change and a drag-drop.
Is dragging data into notepad an option? After you finish all data extractions, you can just copy from notepad, unless you need to drop into different sections.
Or, just use the change event to clear the formatting from the range where you dropped data:
Private Sub Worksheet_Change(ByVal Target As Range)
Place the code in the vb project sheet module, comment out the code when you want to stop clearing formats.