clipboard

I am teaching myself VBA and I have been running a certain task via Copy and PasteSpecial Paste:=xlPasteValues and it completes the macro within 7 seconds. The task is to move the values to the left by one column. I've recently read the clipboard should be avoided when possible thus I used an...

I have a very basic question. I've pasting clipboard content to a certain sheet (Sheet5) in cell A1 (document contains more sheets). Sub Copy() ActiveSheet.Paste Destination:=Worksheets("Sheet5").Range("A1") End Sub I'm been getting a lot of 1004 errors (paste method of worksheet class...

I have been using this spreadsheet, which contains various Macros, for at least 5 years using Office 2010 running on Windows 7 64 without issue. Now when I try to run the macros with Office 2010 running Windows 10 64 pro, I am getting an error" The Picture is too large and will be truncated."...

I am trying to copy a large amount of information from one spread sheet to another but i need to close the first spreadsheet down before i paste the information When i do this i get that annoying message box pop up and have to press yes everytime. Is there anyway i can do it using my vba. I...

Hi all, Thank you for taking the time to view my question. I am looking for a way to attach the hyperlink which i have in my clipboard to an image i add with this code. Is there any one who can help me out with the last part? thanks! Private Sub InsertWord_Click() Dim clipboardData As...

Why wouldn't this code work in a macro activated by a command button! It copies the cell to the clipboard but won't finish with the paste! Stumped!!:confused: P.S. Button is on active cell sheet. Worksheets("Sheet1").Range("N2").CopyActiveCell.PasteSpecial Paste:=xlPasteFormats...

Hello all, I have a problem when I'm using a macro to copy a cell contents then I use ctrl+v to paste to a webform or to another cell in excel. The macro functions perfectly until I put the computer into either "sleep" or "Hibernate". Upon waking I find ctrl+v pastes nothing into the webform...

Hello An application windows is already opened. It is reduced when I clicked a cell in my Excel sheet. How can I recall / select it and copy the content of the clipboard. I think it could be done using the " vbNormalFocus", If so how do I know the path of the desired application. Hope I'm...

I have office 365 and we just had an update. Before the update, I could copy/paste something (ctrl c/v). Then I could select a row and press "crtl +" to insert a new row. The new row would be clean, no pasting of current clipboard. After the update, I press ctrl + and the entire row is filled...

Is there any vba to create a hyperlink to the selected cell/range and directly copy the hyperlink to the clipboard, so that when I paste the hyperlink to another cell, it will link to the selected cell/range? Thanks

Good afternoon/morning/evening everyone! I was hoping someone wouldn't mind helping me with a little code I've had trouble trying to find a working version of on the various forums and articles out there. I have a Macro that pastes clipboard data specifically to cell A9 on the current...

Good Afternoon, Been using the following code for years to clear the clipboard and it worked like a champ, until recently it won't work from a network drive or as an email attachment. This file works with both Excel 2010 and 2016 I get this error: Run-time error '435'...

Hi all, I would like to run a macro that copies specific text to the clipboard. The text does not change - so all I need is to be able to click the macro button and have "loginaddress" held in the clipboard. Any ideas? Thanks!

I can't recall where I pasted it from last year, possibly here, but the macro below used to work sweetly. However it now fails consistently, placing '??' on the clipboard instead of the text in cell B3. <code>Sub CopyTrackDescrToClipbrd() ' Copies text contents of B3 in active TrackDataSheet...

I using VBA / Excel (MICROSOFT OFFICE PROFESSIONAL PLUS 2016) / W10 Pro. I have been using some code (my own) for a while to copy and paste some MT4 code (for Metatrader 4 Forex platform - C++ like code) from a textbox and into my MT4 environment. The code I require is correct and it pastes...

Hi, I have a userform which is being used to import data (that has been copied onto the clipboard from another sheet). I want to make the userform paste it in - but the range of it may be variable. Is there any way to do this paste operation by only specifying the starting cell (A1)? Similar...

The three subs below work fine in windows 7, unfortunatelyI upgraded to windows 10 a few days ago and now it will not work. I get ?? when I paste. Anyone know how I can fix this. Sub Invoicenumber() PlayTheSound "Speech Disambiguation.wav" Dim clipboard As MSForms.DataObject Dim str1 As...

Hi excel gurus! I created a simple form in excel using "check buttons" and "check boxes". I want to copy to clipboard only the selected options by pressing a button. The form looks something like this: Color: [] blue [] green [] red [X] black Fruit: [] apple [X] banana [] grape [X] orange...

Hi to all, Apologies if this has been addressed before. I've been trying to copy values from one workbook and paste them transposed on a different workbook. The current macro using copy/paste transpose works well and does the trick, but takes forever to run. is there a way to avoid using the...

I searched for an answer on this but as common as the error seems to be didn't find one. Dragging data from one cell to another returns "There's a problem with your clipboard but you may still paste your content within this worksheet." It makes no difference what size the worksheet is or what...