1. StuLux

    Trying to paste values only without Select/Copy

    Hi folks, long time since I came to this board for help and many thanks to all those who have helped me in past years. I'm trying to improve my code so that instead of actually selecting a range and then pasting as values I am trying to use the following code Sheet1.Range("B2:F" &...
  2. M

    Clear “ – “ sign before continue with code

    Hi can someone help please I have the following VBA code which is in my worksheet 3 known as “IN” and what this code does is basically cuts and pastes the cell content under column A from my “IN” sheet and pastes it into column C in my “OUT “sheet, but because the “OUT” sheet 4 has a “ - “...
  3. H

    Paste range to first column, then next blank column

    Hi All, I have found my formula for pasting a copied range to the next blank column, but need some help if the next blank column is the first column in the sheet. With my current formula it pastes to column B not A. Many thanks :)
  4. J

    Trouble Copying from txt file to Excel - pastes into one cell only

    Hello. I'm trying to paste from a txt file into Excel. I can successfully paste into ONE cell, but I need it to paste into multiple cells. E.g. the txt file looks like this: 1 2 3 4 5 6 With my code below (admittedly pilfered from someone else!), it pastes into A1, but it pastes ALL data into...
  5. S

    Return maths anser whereby numbers in A and C and symbol in B

    Is it possible to have Excel do an equation whereby, in Column A you have a number, Column B you have a +, -, *, / etc and in Column C you have another number. I have tried a simple =A1&B1&C1 etc but this only pastes as texts and does not pick it up as if you entered that into a cell So I have ...
  6. T

    can i change this vba line so it just pastes values?

    Hi Everyone, Can I change this vba line so it just copys and pastes the values? srcWS.Rows(qty.Row).EntireRow.Copy desWS.Cells(desWS.Rows.Count, "A").End(xlUp).Offset(1, 0) thanks tony
  7. A

    Pivot table selection not Copy/Pasting to Destination Cells

    I am trying to copy a column from a pivot table and paste in a different workbook location. It appears to highlight the proper cells in the pivot table, but when it pastes, it pastes blanks! :mad: I'm at a loss of how to even debug the dang thing. Any help would be greatly appreciated...
  8. M

    Need help with loop through a worksheet copying 3 cells from every 8th column

    Beginning in column N, I need to copy range N5-N7 to a different workbook and sheet, transposing the range as I paste. Then I need to skip 8 columns and do the same with V5-V7, and so on out to Column GH. I should finish with 23 rows on the new workbook/sheet, and ideally, I like these to paste...
  9. J

    Copy/paste VBA code

    Hello, I am a beginner (new learner) of VBA. I am trying to create a macro that does the following: The user will be on sheet "Values" He/she will type in three values in columns A, B, and C. I would like the macro to copy these values, and paste them into Sheet "GL" in cells E6,F6, G6. Once...
  10. B

    Question About Paste and insert?

    I have two sets of code, The first one, copies and inserts the copied range on to a different sheet and the Second, copies and pastes the range on to a different sheet. There is one line of code that has to be different for me. I put the lines in question in bold. Why is this? Does it have to...
  11. P

    Copy sum from database recordset

    Hello forum, I have some code below that I've found that pastes an entire recordset (which is a query) from a database and pastes it in cell A2. Is there a way for me to be able to paste just the sum of a single field from the record set in cell A2? Sheets("Existing Access...
  12. B

    mailto HYPERLINK

    Hiya again folks. I have a HYPERLINK mailto link which Opens outlook and populates the various fields. Is it possible that when the link is clicked and outlook opens, it copies and pastes the text in cell H4 and pastes is as a value into the body of the email window? Many Thanks
  13. C

    Why Is My Loop Not Repeating Correctly?

    I'd definitely appreciate any insight into my problem. Newbie here to VBA but learning quick. My problem is the following: I'm trying to cut & paste a range into some data that has been autofiltered. I'd like the loop to paste until there is no longer data in column A. Right now it only pastes...
  14. S

    Macro to copy data runs too long?

    Hello, I have a spreadsheet with 6300 lines. The number of lines in this spreadsheet can vary from week to week. I have the following macro which looks at column s, looks for "ABC Company", copies the entire row and pastes it on "Tab Client X". It's should find the first empty row starting...
  15. D

    VBA to up arrow and leave blank space before Paste

    Hi, In the below I need it to find "Text 1" leave 1 blank row before it pastes the contents in the selected cells. I have tried to offset but can't get it to work. Cells.Find(What:="Text 1", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows...
  16. B

    ahhhhhh what am i doing

    not sure what I'm doing wrong I set a macro to run which copies a date time from a cell which is =now() ----- and pastes its value to another cell the result was not the correct time lol keeps returning time 19:48
  17. P

    Macro that copy and pastes last used row under last used row

    This is my macro so far. It copies and pastes the last used row under the last used row. I just want it to copy and paste the last row of A-I, but messes up when I try to input it. Dim lRow As Long ThisWorkbook.Activate lRow = Worksheets("Sheet1").Cells(Worksheets("Sheet1").Rows.Count...
  18. F

    Copy from Excel, Paste into Notepad

    Hello, Could a kind person give me a script that... Copies cells A1 to A26 Opens Notepad Pastes cells A1 to A26 into Notepad Thank you very much. Felicity
  19. J

    how to paste with text format using vba?

    Range("A:B").Select Selection.Copy Template.Activate Columns("S:T").Select Selection.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:= _ False Column A,B are from a different workbook, and I would like to paste with text format. However, that formula does not work. Is...

Some videos you may like

This Week's Hot Topics