.pastespecial

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

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

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

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

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

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

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

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

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

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()...

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

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

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

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