pastespecial

Hallo everyone, I have a problem with a pasteSpecial function in my macro. I want to copy a few Excel-sheets from one workbook to the other. For the first sheet it works fine, but for the second one not. When I debugg, I see that by "copy"-order the sheet I want is actually copied (it gets...

I am trying to copy table content from table [Table_eudaxrep.driscolls.com_EUDaxViewReport] (let's call this one TableSource) on worksheet [Data] to another table [Table_eudaxrep.driscolls.com_EUDaxViewReport3] (let's call it Table3) on worksheet [Filtered_Data] after I have deleted all content...

I have tried the suggestions in quite a few different threads to solve the problem that I am encountering. I am trying to copy a Range of cells in a column on one sheet and transpose paste them on another sheet. Sub MoveWell(TCDesc, OnStream, WellCnt) Sheets(TCDesc).Select...

I am using the below code to create a PPT presentation with each slide representing a company asset and some information on it. I am trying to get the Range("V6:W6") to paste as a textbox in the powerpoint but it is only pasting as a textbox. Range("V6:W6").Copy mySlide.Shapes.PasteSpecial...

Hi im trying to run a bit of code thats always worked fine before and has not been recently changed however now im getting this error "PasteSpecial method of Range class failed" when getting to the line in red below Selection.EntireRow.Hidden = False 'unhidden Range("A" &...

Hi Excel PROs I need some help. I'm trying to paste values from all files in a folder to a master folder but i keep getting errors in the paste process. This is my code: Sub LoopThrough()Dim MyFile As String Dim erow Dim FilePath As String Dim DestWB As Workbook Dim SourceWB As Workbook...

Hello, After many searches through your forum and on Google, Ive given up and having to resort to help on the forum. Im trying to copy a range of text from my main sheet and paste it to subsequent sheets - that part works fine. Next Im trying to copy the formatting and paste only the...

Hello wonderful Excel gurus, I have a bit of VBA code I could use help with. It's fairly straight-forward. Based on two cells, tt looks up a value in another workbook, copies it, closes that workbook, and pastes the value where I want it. However, I'm getting a 1004 error. Here's the code...

I have a workbook with 40 or so tabs in it. 30 of the tabs are for scorecards and 10 are for feeder data and charts. The workbook is essentially a Supplier Scorecard. The code I wrote gives me no compile errors, however it is not changing all of the sheets. I am fairly new to VBA so I am sure it...

Hi, I've ben pulling my hair out trying to figure out this simple code. It's supposed to copy values and formatting only from selected rows from a table in one worksheet to another worksheet, removing blanks and duplicates . I've tried multiple ways, which either work and then stop working...

Hello, I'm trying to copy charts from an Excel workbook to placeholders in a Powerpoint presentation. Below are the codes I'm using: <code>Sub Pwp() Dim wb As Workbook Dim ppt As PowerPoint.Presentation Dim pptApp As PowerPoint.Application Dim sld As PowerPoint.Slide Dim shp As...

I have a code to open a file on a shared drive. I am able to copy and paste the contents of a worksheet, however I would like to paste special with formatting and values. Additionally, the copied material is grouped and I would like to paste it ungrouped. Here is the code I have thus far: Sub...

I've got a macro building a powerpoint presentation from my excel spreadsheet. I really want the powerpoint to update when I save changes to excel (probably using link?) but I can't figure out the syntax. The section of code I have right now is: 'Loop through each chart in the Excel worksheet...

Dear all, I am trying to paste a formula in a range it says "can not execute in break mode". Please take a look into my code below. Dim lngMyRow As Long Dim lngStartRow As Long Dim lngLastRow As Long Dim rngMyRange As Range Application.ScreenUpdating = False...

I'm a bit brain dead tonight and cant make this work. Simply trying to copy the range from N4:N5 to the entire columns of O and T, both starting in row 4. Row length will be variable from sheet to sheet. Here is what I have.

Hi, I have set up the below to copy any rows which contain a matching PO value from one sheet and put them into another sheet in. Sub InpInvExtSbc() Dim oPO As String Dim LR As Long, i As Long oPO = Sheets("Input Invoice").Range("L9") & "-" & Range("L20") With Sheets("External Subcontract")...

See code below. Sub runallmacros() Dim wbSource As Workbook Dim wsDest As Worksheet Dim row As Integer, os As Integer Set wsDest = ThisWorkbook.Worksheets("File Copier") row = 2 os = 0 With wsDest Do While .Range("K" & row).Value <> ""...

I have to copy data from sheet 2 to sheet 1. Sheet 2 has a bunch of hidden columns (I don't know which they will be ahead of time). This works to paste formulas, but I need values: Sheet2.Range("B8:AM28").SpecialCells(xlCellTypeVisible).Copy Destination:=Sheet1.Range("A12") I must past...

Okay, I've been searching all morning and I'm having trouble getting this code to work: Sub CommandButton1_Click()MyBook = ActiveWorkbook.Name ' Retrieves the name of original WB. Columns("A:A").AutoFit Columns("B:B").AutoFit Columns("C:C").AutoFit Columns("D:D").AutoFit Range("A5:D500").Select...

Thank you for reading:pray: ;) I want to copy a range from Excel containing formatted text in cells to Word. This is what I have so far: Sub ExcelToWord() Dim wdApp As Object Dim wdDoc As Object Set wdApp = CreateObject("Word.Application") Set wdDoc = wdApp.Documents.Add wdApp.Visible = True...