.pastespecial

  1. N

    Commenting the below macro

    HI All, Could someone please help me comment out the below macro on what each or a line does. This is used to auto assign task but I am trying to tweak few things but dont know where exactly i need to change things up. If someone can help me comment the line for example 'This splits colums or...
  2. R

    Save As Error 1004

    This is my code: Dim New_file_name New_file_name = Application.GetSaveAsFilename("Verbruik_LT_" & Format(Now(), "dd-mm-yyyy hh_mm"), "Microsoft Excel Workbook (*.xlsb), *.xlsb") Set NewBook = Workbooks.Add Verbruik_LT.UsedRange.Copy With...
  3. M

    Copy Sheet and paste value with formatting to new sheet VBA

    Hi been a consistent user of this forum and never had the chance to ask anything. But hoping someone could help me with this. I have 4 sheets in a workbook and I want to copy and paste values a range with formating to a new workbook. I have completed the following using the record feature and...
  4. J

    WorkSheet_SelectionChange Not Working (Tried the obvious stuff)

    Hi I have the following code in the sheet where the target cells (H20 & N20) are Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$H$20" Then DespatchAddress End If If Target.Address = "$N$20" Then ReceiptAddress End If End Sub The expectation is...
  5. J

    VBA to increase cell value by 1 and loop code

    Hi all, I have the code below that works as needed, but I'm looking at enhancing it further. I want run the code below, and then have cell F5 increase by 1 and then rerun the code below. I want to do this until F5 hits 40. Appreciate any help and assistance. Range("P8").Select...
  6. C

    Send XLS in email body

    I am using the code below to email my xls info in the body oif the email. I would like to be able to add some text before the data. Addionally I would like to specify what email address it is sent from and to use that address outlook signiture. Can anyone help? Sub SendSelectedCells() 'Copy...
  7. D

    Paste special

    Is there a paste special property for the pasted text to be only a date, without formatting, such as background etc. I have: With Worksheets(Combo).Cells(Lastrow, 1) .PasteSpecial Paste:=xlPasteValues .PasteSpecial Paste:=xlPasteFormats End With but it copies formatting...
  8. W

    send xls to email

    I had been using a macro from Ron Debruin to do this but lately it ran real slow. So I found online another macro, trimmed it and added some of Ron's to it. It runs very fast. But the issue is the data it sends to outlook seems to start mid page and goes right. I can not seem to get it to line...
  9. P

    Creating image file from Word document failing

    This Excel VBA code used to work perfectly for over 100 Word documents displaying metrics that consist of several shapes, charts, etc. The goal is to save the Word document as an image file since the monitor that displays the metrics don't support Word. But now .PasteSpecial results in only the...
  10. M

    Copy and pasting Data (on the same sheet) using VBA

    Hey Everyone! I'm having trouble writing code to copy data from a table and paste the important columns under the original to compare the data. I needed to put this in a loop to go through all the sheets of the workbook.. Here is my code.. Any help will be appreciated! Sub CopyData()...
  11. R

    VBA to copy based on specific criteria

    Hi Guys I'm new here and I have been searching for hours, so please forgive me if there is a thread for this already. I have a data file, approx 20k line items that I need to report on. From this data certain line items needs to be copied to other worksheets in the same workbook based on...
  12. P

    copy rows from table with criteria and paste to end of another table

    Hello Everyone, i am trying to copy raws/data from one table with 2 cumulative criteria: Hours & Jobcode should be completed. I then need to paste it at the end of another table. I have the following issues with my current code: - No critera for copying - Copy all raws until last row with data...
  13. N

    Pastespecial how to not mess up manual format

    I am trying to paste special and manually format the object to a certain scale. However, the scale size always changes. Here is my code: With Selection.Tables(1).Range.Cells(2).Range .PasteSpecial Link:=True, DataType:=wdPasteOLEObject, _ Placement:=wdFloatOverText, DisplayAsIcon:=False...
  14. M

    VBA Syntax

    Trying to get this reference to work to a closed workbook on another drive. I just want to copy data plus cell formatformatting: Sub CopyWithFormatting() Workbooks("\\harddrive\driveletter\folder\[XLworkbook.xlsm]").Worksheets("sheetname").Range("c6:ak27").Copy With ActiveSheet.Range("c6")...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top