paste special

  1. L

    Paste Special Images excel 2010

    Hi, I'm sorry if this has already been answered - I tried searching but couldn't find an answer. I found a macro on the internet that automatically pastes images from a folder into column A of my workbook. (I work in publishing and am creating a catalogue with ISBNs in Column B, all the images...
  2. H

    Copy/Paste Issues

    I can not seem to be able to copy & insert/past. I also can not seem to copy a set of rows with formatting & formulas, then when I paste to a another row, it drops the formats & formulas. When I attempt the paste special, it only gives me the option to paste text. The only option I know of...
  3. M

    Paste Special and Format Painter not working

    Hi everyone, You were recommended to me for help solving a really frustrating problem affecting myself and some of my colleagues. Thanks in advance for your help! Basically, the Paste Special menu is greyed out on our spreadsheets, in whatever file we open, so you can only copy and paste in...
  4. C

    Copy and paste a cell reference?

    Hello, This is an Excel 2007 and Excel 2010 question (I use both, and guess the answer will be basically the same for both): In the same way I can paste a value into formulae with "paste value", is there any way to paste a cell reference? For example, I've attached a simple example below...
  5. B

    Paste Special Function

    I have "lost" the normal 'paste special' feature in excel 2007!!! When I click on the paste special feature it presents a dialog box allowing paste as "unicode text" or "text" ... rather than pasting formulas or numbers or transposing. Any suggestions to get back to normal ?? Thanks
  6. F

    Swap pasting - cutting and pasting cells' contents

    I'm doing a ton of corrections for mixed up information. Is there a function that will cut and paste a cell's contents and automatically push the destination's cells contents to the original cell that you cut from? i.e. - Swapping contents... if that does exists, I'd assume I could assign a...
  7. W

    Paste special charts using loop

    Hi, I encountered problem when using code to copy&paste charts as enhanced metafile from one sheet to another. Programme is not responding for quite long time then it diplays 1004 error. I suppose problem is in the line: ActiveSheet.PasteSpecial Format:="Picture (Enhanced Metafile)"...
  8. S

    Macro Insert Row Below Copy Formulas and Formats

    Greetings, I have a spreadsheet in which we sometimes need to insert a row right in the middle of a bunch of filled-out rows. I'd like to have the inserted row contain the same formulas and conditional formats as the other rows, but not copy the text/values. I've tried a few things but...
  9. K

    can't paste special add value

    Hello, I have a group of cells that I can't add a value to using the paste special add value function. I have reformated the cells from text to general also to number. I have tried text to columns and nothing seems to work. I can do it to other cells on the same sheet. The data and formating of...
  10. T

    Paste special formulas wont work?

    i have multiple excel worksheets (12) 11 of which use data queries 1 for a master list. the Master list is programmed with 4 VBA buttons, 1 to clear the list, 1 to extract the data from the other sheets making a new list, 1 to format the list, and the last 1 to add formulas (IF functions...
  11. E

    Pasted links into pptx.

    I have a multipage work book (xlsx) and a single sheet powerpoint document. I have pasted data from the workbook into the pptx using paste special/paste link/object. Having saved both in the same location, once I reopen the pptx and click "update links" I receive the following message; "Some...
  12. A

    Excel Macro to paste special-> transpose (only cells with data)

    Hi All, I have been searching this and other threads to find a solution, but could not find exacly what I am looking for. I have data as shown below (Sheet name : "Input") : <TABLE style="WIDTH: 336pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=448...
  13. S

    Copy - Paste Special query

    Hi there, I have a standard template in PowerPoint (A4 sized) which I populate with a series of tables and charts generated in Excel. I tend to copy then paste special to create an excel linked object which is fine. The problem is that when I paste the item PowerPoint tends to resize it...
  14. B

    Excel 2010 linked chart not showing up...Bug?

    I have 3 excel workbooks. I am attempting to link a chart from workbook1 to workbook2 by the paste special method. Workbook2 already has a linked chart in it from workbook3 and works perfectly fine. But when I link a new chart from workbook1 to workbook2 only a blank object appears. The...
  15. A

    Excel - PowerPoint Paste Special Problem

    We recently installed Office 2007 (from 2003) and many of my colleagues are having the same 'paste special' problem: - In 2003, we could color code excel data (e.g., blue, red, green) and then paste an enhanced metafile into powerpoint and the chart would show black and white text, as desired...
  16. A

    VBA Copy Row and Paste as Formulas "X" number of times

    I have been kindly supplied with the following code that allows the Document User to define the number of rows to be inserted in a Worksheet. Currently this code copies row 3 and pastes it the defined number of times beneath the last used row. However I would like to tweak the code so that...
  17. J

    Paste Special Values Not Working

    Hey Guys, First time post, Not sure what is going on, Happens all the time but usually just drop it and try something else... I am trying to copy a range of cells and Need to transpose the values. Easy Enough? When I right-click and paste special, it gives me a new window with an array of...
  18. W

    Excel 2007 - incorrect chart pasting into Word

    Hi all, I've got a complex workbook with lots of linked data - on one sheet there are 8 fan charts showing financial data. When I paste the charts as pictures into Word 2007 , everything is fine. This is all on XP. However, when I try to paste special them as linked Excel Chart objects, 4...
  19. S

    Search column; copy contents/paste special

    Hello, I'm using Excel 2007, and I'm looking to create a macro that searches P4:P542 for all values which include an integer greater or less than (but not equal to) zero. For each value it finds, I would like it to copy and paste special the contents into the cell below it. I'm fairly new at...
  20. K

    paste special problem

    I am trying to copy a set of filtered data into a PPT presentation. I am copying the selection, then using Paste Special to create an object in PPT. When I open the object, most of the data that I copied isn't there. It appears that the rows in the object are still filtered, but there's no...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top