pastes

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

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

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 :)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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