1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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 "" myIE.Visible = True...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. S

    PasteSpecial Method of Range Class Failed

    I would like to be able to take data presented along a single row and have it moved to a single column. The code below is what I have constructed in order to accomplish this task. I am receiving an error "Pastespecial method of range class failed" on the line immediately below. Why is it...
  17. R

    Problem in getting PasteSpecial together with Unicode text to paste where I want.

    I can get :- ActiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:=False to work. But setting the active cell is not straightforward. Workbooks("myBook").activate always works but Cells(1, 1).select (and Cells(1, 1).activate) sometimes work but are both unreliable. Can...
  18. R

    On error and paste.special

    I have a sub which starts with an On Error GoTo and then continues to use a PasteSpecial. (I can paste code if required, but I suspect there may be an easy answer from someone here!) Now if there is nothing to paste it does not go to the label but just stops at the PasteSpecial. I suspect this...
  19. E

    Resize a picture of excel chart and paste into word

    Hi, Hope you can help. My VBA code copies excel charts and then pastes into word doc which has bookmarks. How would I resize the copied chart after it is copied so that it will fit in the area of the doc? Sub Chart_copy() Dim wdApp As Word.Application Dim wdDoc As Word.Document Dim...
  20. S

    VBA Noob, PasteSpecial problems

    Hi Folks, Complete VBA Noob here. Been reading these forums for a long time. Finally found a topic I can't find anywhere. I've got a number of frozen panes at the top of a spreadsheet referencing the active row of the same sheet. I've used this code to transpose my active cells to the...

Watch MrExcel Video

This Week's Hot Topics

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
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 "".
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