Generally, the P command (upper case, different from p) pastes the contents of the clipboard before the cursor position. Is that what you’re looking for? (I’m not quite sure what you mean when you say you press Command+I, as my keyboard doesn’t have a Command key.)
Ask him what will he do when he finds a bug in his code. How many places will he now need to fix it in? You can also show him the answers to this question (Why is “copy and paste” of code dangerous?).
Options, Text Editor, HTML, Misc, Auto ID on Paste By the way, the most similar article contains just the same question (answered, of course). Be more careful next time 🙂
The use of navigator.clipboard requires a secure origin. So if your dev environment is being served over HTTP, then the clipboard method won’t be available. According to MDN Clipboard docs This feature is available only in secure contexts (HTTPS), in some or all supporting browsers. Maybe you could check if this method is available with … Read more
If you are wanting to just copy the whole column, you can simplify the code a lot by doing something like this: Sub CopyCol() Sheets(“Sheet1”).Columns(1).Copy Sheets(“Sheet2”).Columns(2).PasteSpecial xlPasteValues End Sub Or Sub CopyCol() Sheets(“Sheet1”).Columns(“A”).Copy Sheets(“Sheet2”).Columns(“B”).PasteSpecial xlPasteValues End Sub Or if you want to keep the loop Public Sub CopyrangeA() Dim firstrowDB As Long, lastrow As Long … Read more
I’ve copied text from the Console window and pasted it into another source many times. It’s there as default in a Console application; Right click the console border: Select Edit > Mark: Drag over the text you want using the mouse (Or use the arrow keys) to select the text you want: Again, right click … Read more
I’m adding a late answer after nearly 3 years because with the current Chrome Dev Tools, neither approach work if you have an Array or even just a nested Object property in that variable, following both answers you’ll just end up copying a string with a lot of Array[size] or Object strings interleaved in the … Read more
Yes. Put before the command the number of times you want to repeat the action. And this works with many of vim commands. It would be: 30p
From http://spreadsheetpage.com/index.php/tip/making_an_exact_copy_of_a_range_of_formulas_take_2: Put Excel in formula view mode. The easiest way to do this is to press Ctrl+` (that character is a “backwards apostrophe,” and is usually on the same key that has the ~ (tilde). Select the range to copy. Press Ctrl+C Start Windows Notepad Press Ctrl+V to past the copied data into Notepad … Read more
You might find inspiration from ScreenshotMe. Basically you need different parts: something that takes the image out of the clipboard and uploads it to the web: this could be a java applet, flash or firefox extensions. Flash or Java would have the advantage of being cross browser then you use the <canvas> tag to display … Read more