pastespecial

  1. L

    paste filter results in new sheet or workbook with paste special not working.

    Hi All, Greetings, I am new to this forum or any online forum to be precise. In case I do or say something wrong please bear with me. I am new to excel and trying the below code to copy data after filtering to a new sheet(if you could tell me how to paste in the new workbook will be...
  2. D

    Range("A1").End(xlDown).Offset(1, 0).Select

    I have a case/call audit sheet in which I am trying to move the data between other sheets, yet having no luck. I keep getting the Run-time error'1004': Application-defined or object-defined error. When I debug, it highlights the following line: Range("A1").End(xlDown).Offset(1, 0).Select...
  3. S

    PasteSpecial method of Range class failed

    I encountered a problem where 1) I cannot paste the copied contents into the desired cell, and 2) an error 1004 PasteSpecial method of Range class failed popped up. Here's my code: 'copy whole content from old quarter file with header added Windows("Report002_" & year &...
  4. T

    Word Crash, paste fail and colour loss during VBA Macro when Pasting Image from Excel

    This code is driving me insane. I have created a macro that is structured as below. It creates a chart based, copies it from an Excel Chart tab and pastespecials it into word. Creates a page break, clears the clipboard and does it again for a total of around 100 times. Please see the below...
  5. A

    Excel VBA, Randon error of <Range>.pastespecial failed

    Dear All, Am calling a function from a sub by passing a string (picture path) and a range variable (Cell address). The function then inserts the picture and pasts it over range Issue: The function gives 1004 error on <range>.pastespecial command but not every time. and pressing F5 in debug...
  6. V

    Macro to copy range including hyperlinks but not formulas

    Hi! I am trying to copy a range (A1:A7) from one sheet to another. All cells in range have formulas and one cell in particular (A1) has a hyperlink. What I am trying to do is copy everything and paste it to the destination sheet except for the formulas. I tried to use .PasteSpecial xlPasteAll...
  7. M

    VBA to copy data from multiple work book to one work book

    hello, I want macro for copy data from multiple(nearly 100) workbook placed in one folder to one master workbook with detail bellow. All work books having sheet name "list" from that sheet I want to copy cells C9, H9, H10 and H24:H29 from which H24:H29 contains formulas but in master work book i...
  8. B

    "PasteSpecial xlPasteFormulas" with relative reference with destination ListObject

    My goal is to copy-paste formulas from tableSource (a ListObject) to tableDest (also a ListObject) and to have those pasted formulas refer to tableDest, not to tableSource, which is what I get when I do a little something like this: ListObjSource.ListRows(1).Range.Copy...
  9. M

    PasteSpecial & xlPasteValuesAndNumbersFormats

    Hi All, I can't seem get my code to work where on the Input tab I want cell D4 to copy and paste just values and numbers into the B column on the KM Tab. There is a formula in D4 which is (=MAX(Detailis!B4:B51)+1) which results in 'D005' and will increase when new items get added to the list...
  10. D

    Pastespecial Macro Error: 1004

    Hello Everyone, This is my first post so apologies if I have done something wrong. I have 2 spreadsheets , one for Planning and the other one for daily whereabouts. both mirror themselves and have Data validation fields with lists defined, since when I copy from the planning to the daily...
  11. L

    VBA PasteSpecial method Worksheet class failed

    Hello everyone, I have a code which starts this: Private Sub CommandButton1_Click() Dim destination As Worksheet Set destination = Worksheets("STATS") Set myIE = CreateObject("InternetExplorer.Application") myIE.Navigate "https://www.internetpage.com/lblabla.html" myIE.Visible = True...
  12. H

    Multiply then copy

    Hi - Is there a way to use a macro to multiply .Range("P" & .Rows.Count).End(xlUp) and ws1.Range("A10") then paste the value in ws1.Range("C10")? I guess I could use .Formula, but I was also reading about PasteSpecial and xlMultiply. I just haven't been able to figure out how exactly to use...
  13. M

    PasteSpecial macro not working after cut

    Hi, I am trying to cut a range in workbook1 and paste it using a PasteSpecial macro in Workbook2, but I am getting an error. The PasteSpecial macro works fine when I copy the range instead of cutting it. In macro 1, I use the following code to cut a range into the clipboard: Range(Temp...
  14. E

    VBA Code to combine VLOOKUP and Pastespecial

    Every morning I have to manually copy and paste information from cells because VLOOKUP doesn't carry over formatting. I am very beginner to VBA.... Basically I have cells that contain information laid out like such: <tbody> Product Name DOCKET ABC <del>1234</del>TEST BCD 2345 TEST...
  15. E

    VBA PasteSpecial causing Run-time error

    Good Morning, I have a workbook containing 7 sheets (4 of which are 'project list' working sheets, and 1 a summary sheet 'Gantt'). The gantt sheet has 4 contiguous tables with headers and a gantt chart line for each listed project in column D. It's format is not the same as the working sheets...
  16. Small Paul

    Paste Special - Run-Time Error 1004

    Hi I am having difficulty with a Paste Special line in my VBA and cannot work out why. I have searched various websites and tried a load of different things, without success! The section of code is: Worksheets("Required Data").Activate ActiveCell.Offset(0, 2).Copy detail = ActiveCell.value...
  17. H

    Combine 2 Macros

    Hello, I have a workbook with 3 sheets, I am trying to copy the first 2 sheets to a new workbook without formulas. Each sheet needs a set range, which is different, can I combine these 2 Macros together? Sub JointingTracker() Sheets("jointing Tracker").Copy Range("A1:P70").Copy...
  18. J

    help on syntax logic on paste special

    Hi everyone I have a small issue here and would like to seek some advice from the veteran around here. I did the following code to copy and paste some information. however, I have managed to achieve a copy and paste into the worksheet I want. How do I change the part that's in red to copy and...
  19. H

    macro to copy data from sheet3to sheet4 using paste special values

    I have the following code which I have written to copy data from sheet3 to Sheet 4 using paste special values I get invalid qualified when running the macro PasteSpecial Paste:=xlPasteValues.Sheet(4).Range("A1") It would be appreciated if someone could amend me code Sub...
  20. J

    Pastespecial Triggering Worksheet_Activate to run

    Greetings, When running the code below in a new workbook, with Sheet1 activated and with application.enableevents=True, the PasteSpecial line causes the Sheet1 and Sheet2 Worksheet_Activate codes to run (as well as their respective Worksheet_Deactivate events. Moreover, when the pastespecial...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top