Log In
Register
Home
June 15, 2022
Offline
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
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Hi Gob,
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)
Target.ClearFormats
End Sub
Place the code in the vb project sheet module, comment out the code when you want to stop clearing formats.
1 Guest(s)
