paste between workbooks

  1. A

    xlPasteValues not working, need to match destination format, but getting error

    Hi! So i have a data set that is exported by a database, so can't change it's format. I have a script to copy and paste it into my sheet and it works fine: 'set the range reference variables Set Bk = Sheet3.Range("C5") 'file path of book to import from Set Sh = Sheet3.Range("F5") 'sheet to...
  2. K

    Using VBA program to copy and transpose on to new sheet

    Hello! I am trying to write a program that lets me select a file, after selection it would then open the file and copy the contents in the first sheet. From here I want the code to paste (transposed) the data on to the second sheet of that selected file. Right now, this code is pasting the...
  3. L

    Excel formula or VBA to paste list of data from reference worksheet if specific text is selected in data worksheet

    Hi, hoping someone can help as I cannot find a solution at all. I have a workbook with two sheets. One is the active data sheet (sheet 1), the other is a reference / list (sheet 2). Sheet 2 details across the columns (C:E) the 'Types', and below each type, lists the Tasks for that type (used...
  4. V

    Need to identify source of 424 VBA error

    Hi guys, I have not posted recently or worked with VBA in some time and am now trying to write this VBA program to transfer a copy of the same profile limits from a static file ("Profile" file) to a series of result files (listed as Gen5 Result files or Destination). I wrote this code but it...
  5. D

    Excel-Macro: Paste Link to a new worksheet (Run-time error '424': Object required)

    Hey, I am currently working on a macro for duplicating a worksheet and pasting specific values from it into a new column of a remaining worksheet. However, whenever I try to paste link specific values to another worksheet, I receive the message 'Run-time error '424': Object required'. This is...
  6. H

    Failing paste special to another worksheet

    Hi, I'm attempting to copy from one file to another. Successfully. Next step is to bring (paste) it to the correct position within the file. That's failing in the last row of this code. What could solve this issue? Support is appreciated! Thanks Hans (Netherlands). 'Transfer to another file...
  7. C

    Methods of Copy/Pasting between different workbooks

    Hi. I've been using VBA for about 2 weeks and I'm struggling to find a method of copy/pasting between workbooks into a specific range. I've tried multiple different methods I've found on google and from other threads on this forum, but it always fails and gives me a 1004 error at the same line...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top