paste

  1. D

    Copy and Paste Multiple Times

    I just want to know why I am the Visual Basic Applications (VBA) script isn't working as it should be. I am trying to copy and paste multiple tables, depending on the value I put into cell E1. I've used this code here: Sub CopyMulti() Range("A3:D19").Copy Range("E15").Resize(14 *...
  2. M

    How to Stop Excel From Adding Spaces on Newlines when Copying Text Out of Program

    Hi, I'm attempting to copy an Excel cell, and paste it into another program (in this case, Adobe Analytics). However, it's inserting a space after every newline. Ex: Instead of this -It does this -And this -Etc (but instead of "-" it just does a space) When I paste it as text to MS Word, and...
  3. L

    Help with Excel Formula

    I have the below formula that am trying to paste but for some reason is not taking =, what am i doing incorrect =AND([@Date]>=Calculation!$D$2,[@Date]<Calculation!$D$2+7) See sample link the sheet is called Raw Data but is calling from calculation...
  4. A

    SMS with App

    Hello All I want to open an application with any code in attached and want to send these number one by one through that application! That application is bushbullet, which linked with my mobile msg box! https://www.pushbullet.com/ for more understanding! When I hit button in sheet that call...
  5. J

    VBA Code to Work down a list, calc a result, add result to bottom of new list

    Hi All, Any help here would be appreciated greatly. CODE SEQUENCE 1 Copy Item A from List A 2 Paste flat to B2 3 Recalculate the result to update C2 4 Copy range B2:C2 5 Paste flat to bottom of List B 6 Goto next cell on List A Repeat steps 1-6 Stop at bottom of List A...
  6. G

    Paste as Values

    Set Template = Sheets("Template") Template.Select Template.Copy After:=Template Sheets("Template (2)").Name = "ABL" Hello all, The code above is working to copy one sheet and move to a new sheet. However, I want to paste into the new sheet as values. I'm not sure how to do that...
  7. V

    Three spreadsheets to become one

    I keep records of electricity, gas and water consumption, which at the moment are on individual spreadsheets. I want to create a functioning spreadsheet of three original sheets to contain those I first mentioned. Copy and paste seems not to work, as each new item posted to the recipient sheet...
  8. A

    VBA grammar for sum of two fields in SQL table

    I have an SQL statement that sums up two fields and is working find in SQL Select w.Forecasted_hours + w.actual_hours as 'TotalForecast' however in VBA I'm not exactly sure what would be the right way to do it. If I paste the SQL it seem like not recognizing a plus sign. Can anybody please...
  9. M

    How to copy formula text ONLY from a cell then paste it into a cell in another workbook?

    Hi I'd like to copy the text of a formula in a cell, then paste that text into a cell in a different workbook, without the formula changing. I can't use 'copy' then paste special xl paste formulas, because the reference changes when the formula is pasted into the other workbook. What would...
  10. M

    Finding the end of the body of an Outlook Email

    I want to paste two ranges into an Outlook email. I can create the email, filter for the range, copy and paste the range. The problem is with where the second range pastes. In the first three emails, everything works correctly. Then, the code does not correctly find the end of the message to...
  11. I

    Advice for code copy / paste userform to cell range

    On my worksheet called Sheet1 i have a range I26:I35 with values in. My intensions are to press a transfer button on a userform & select a Month. This will copy the cell range values shown above to 1 of 13 possible paste locations on the same sheet depending on the MONTH selected from the...
  12. S

    Remember the last thing copied

    Hello ppl! I googled my problem before posting but couldn't find anything helpful so i decided to ask here. Is there an option to remember the last thing i copied and paste it after doing several actions in between ? For example > I have to copy some text and paste in one cell, than i change...
  13. H

    Offset after loop

    Hi All I would like to copy all non-blank cells in range R5:X7000 into the adjacent cell in Range K5:Q7000 as paste values. Essentially any non-blank cells will paste as a value in same row but 7 columns to the left. I have what I think is a good piece of code but need some help how to edit it...
  14. V

    formula/code/vba

    There is any code or vba or formula which can do the following 1. We are copying a data/formula 2. Now we want to paste it as values in a active cell, My problem is that every time data size is changed so formula/code/vba will work when we use that command/vba/code for paste values on that cell
  15. C

    Conditional formatting

    In conditional formatting I would like to highlight the whole row when yes is entered into cell M2 then each row after that. Sorry cannot paste table into here Thank you for any assistance <colgroup><col><col><col><col><col><col><col><col><col><col><col><col span="2"></colgroup><tbody>...
  16. E

    Data Validation Circles Blank Cells Even With 'Ignore Blanks' checked

    I have a large spreadsheet that I have pasted values into from another worksheet (I literally used 'paste values' from the context menu). The sheet I'm pasting into is set up with drop down menus that the data i'm pasting needs to match. I am attempting to us data validation circles to find the...
  17. E

    Data Validation Circles Blank Cells

    I have a large spreadsheet that I have pasted values into from another worksheet (I literally used 'paste values' from the context menu). The sheet I'm pasting into is set up with drop down menus that the data i'm pasting needs to match. I am attempting to us data validation circles to find...
  18. J

    VBA Copy & Paste Data Loop

    Hello, I am looking for VB code to copy data from one sheet, and paste it onto another sheet in a different format. Here is the current format: <colgroup><col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;"> <col width="88" style="width: 66pt...
  19. A

    Chart expanding

    Hi Folks, I am currently working on pivot tables and charts. I have charts on one sheet and when I copy a pivot table and paste it onto the charts sheets the charts expand. How can I prevent the charts from expanding when I copy the pivot table or for that matter any text. The expansion is...
  20. T

    Macro to go up one line

    I have a form that adds data to a table, I have a macro that adds a new line to the table, but I would like to copy and paste as value the previous line once I've added a line. When I record the macro though it puts a specified range in but I would like to just have it say go up one line and...

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Syntax errors
    Good Morning, Trying to compile a workbook, I keep getting a few errors. Here are the first two: [code=rich]Syntax Error: Function...
Top