paste special

Hi As the title suggests i am unable to use the paste or special paste option with a single workbook, it works fine in other work books. The is extensive vba coding and forms in the effected book. it is not add in related nor is it Skype click to call related, although it may possible have been...

Hi all, I have quite a bizarre error occurring with the code below - when the button is pressed to run this code I get the Run time error 1004 - Paste special method of range class failed. However if I step through the code no error occurs. The error is occurring at the "paste special" stage...

Hi all, I am struggling this. I have a worksheet with lab data in that is imported into my workbook. From row 4 downwards each line of the workbook contains lab data: In column C the units of the tests are given -either mg/kg or ug/kg. From column D across to AD each cell will contain lab data...

Hi All, How would you go about creating a VBA macro that would copy from your SELECTED cells (army ants -----) and paste special values into your ACTIVE cell (cell that is current focus). Something like this - but where Range"A1" is dynamic to pick the SELECTED cell and Range"B1" is also...

Hello all, I wonder if you could help me please? I am in the process of creating a worksheet but i feel like i have hit a brick wall. I am using Excel 2013, I have a workbook with 8 sheets in. I have one sheet where all the main data is and then i have a further 7 sheets of various stages...

Dear all, I am trying to copy and paste multiple tables from Excel to PPT, using VBA. This works if I paste it as an Enhanced Metafile Picture. However, I would like to paste it as HTML format, so I can adjust the table later on in Powerpoint. Changing the PasteSpecial parameter in the code to...

I am trying to copy all the visible cells from a sheet, then paste everything but the formulas into a new sheet. My current code works fine, except it does not paste the charts onto the new sheet. Is there a way to do this? Sheets("Original Sheet").Cells.SpecialCells(xlCellTypeVisible).Copy...

Hi, I recently posted a query but it was more like a project. I am solving one by one. I have already sorted column A to C based on column A values. Now I need to copy and paste column A in Sheet2. But in Sheet2 I want each row should contain only 10 values, the remaining values should go into...

Hi, I like to maximize efficiency and go really fast when I work with data. I'm pretty good at doing this too, but Excel 2010's keyboard shortcuts to retrieve the paste special values menu prompt is slowing me down. I access this dialog/prompt all the time and I am annoyed at how...

Creating a Sport Draws & Results spreadsheet. The first sheet is "This Week" while following sheets are "Netball", "Football" etc. In a sport sheet there are rows of data that contain the team, date, time, opposition, location, and results. See below: <tbody> 1st XV Boys Wed 14-Aug 7 pm v...

Hi. I'm writing a visual basic script to paste some cells onto a new sheet, however one of the cells is computing a formula, so instead of pasting the formula cell, I want to paste special. Here is my existing code. I've tried using other forum posts, but none seem to work. I only want to...

Hi all... first post here. I tried looking for this in various Copy/Paste threads but couldn't find exactly what I needed... The following code works fine except for the fact that it takes a long time (2 to 3 secs in 5 lines) for this for loop to run and I'd like it to do the pasting in the...

When I mark some cells (a table) in an Excel file, copy it and then try to paste it to a Word document; I sometimes get the opportunity ”paste special” which I want, but sometimes I only get ”paste”. I cannot find out why I sometimes only get ”paste”. Does anyone have an answer how to ensure...

I am trying to write a VBA macro where I can put my cursor in a cell at the top of a range of cells, where the number of rows can vary each time, and select the list of cells and then copy them to the adjoining row. When that is done I want to return to my original list and copy them again and...

Hi, I have several Macros on this theme I would like to create all with the aim of copying a column and pasting values elsewhere in the worksheet according to what the current month is. Say I have a cell B2 with a dropdown of Months (Aug-Jul). I have a range "Spend_In_Scope_Forecast" which is...

Hi there! This is my first post here, as Excel and me have been good friends so far! Now I am only trying to subtract a range from another and can't make it work! The ranges are in different workbooks, but same size. I'm using Excel 2003 and here is what I have: Sub Main() Dim...

Dear forum member repairman615 provided me with this useful code Sub Transfer() Dim c As Long Dim wsD As Worksheet: Set wsD = Worksheets("Sheet2") 'Data Worksheet. Dim wsR As Worksheet: Set wsR = Worksheets("Sheet3") 'Results Worksheet For c = 2 To 1002 'Loop through 1000...

Hi, I am trying to copy and paste conditional formatting. I can successfully copy the conditional formats with paste special format. However it seems to change all my relative references to absolute references in the formatting formulas. I want the references to remain relative like they do in...

I am trying to write a "script/VBA" that would copy ONLY THE VISIBLE CELLS in a specified range (A4:H75) and paste them AS VALUES into a new worksheet. Then email this new worksheet to the email address in the original spreadsheet's cell A1. Please help!

Hello all, I have this issue where when I want to paste what i have copied i no longer can access the paste special buttons, i only have the posibility to paste as text, i can not paste formular for example. I tried check/uncheck the show paste options button, i tried adding the menu to...