Error While Pasting The Data

i get the error "data on the clipboard is not same size and shape as the selected area,do you want to paste it anyway"
and is i click yes i get an extra columns with some weird data
could any one please let me know how i could remove this or set the size or do anything to get my data pasted properly.......please help.......
its urgent...:-(


Free Excel Help Forum

- Ask any question about Excel and have it answered in no time.

Similar Excel Tutorials

Error bars in Charts in Excel
How to add, manage, and remove error bars in charts in Excel. Error bars allow you to show the potential variance ...
Remove Vlookup #N/A Error in Excel
How to remove the #N/A error from Vlookup and replace it with a friendly message or a blank cell. Fix the Vlookup ...
Prevent Errors From Appearing in Excel
How to prevent errors from appearing in formulas in Excel. This is especially helpful for the Vlookup function. Sec ...
Simplify VBA Coding for Common Functions
' These modules exist just to make other VBA code easier to write and more readable ' For example, you can just ent ...

Helpful Excel Macros

Excel Macro to Save a Specific Worksheet as a New File
- This Excel Macro allows you to save a specific worksheet within the Excel Workbook to its own new file. You will be a
Save the Current Worksheet as a New Excel Workbook File
- This Excel Macro will save the currently visible/active worksheet (the one that you see when you run the macro) to a
Excel Macro that Searches Entire Workbook and Returns All Matches
- This is the ultimate Lookup Macro for Excel. It will search every worksheet in the workbook and return all of the mat
Filter Data Sets on Multiple Columns with Multiple Criteria at Once in Excel - AutoFilter
- This Excel macro allows you to filter a data set on multiple columns and criteria at once. This means that you can filt
Filter Results in Excel to Show Only Those that End With Specified Text or Words - AutoFilter
- This free Excel macro filters data to display results that end with certain words, text, or characters. This is a very

Similar Topics







Hi all,

I'm trying to copy large amounts of data yet excel keeps posting the error message,

Code:

"Information cannot be pasted because the Copy area and paste area are not the same shape and size".


Is there anything I can get around this.... there are merged cells within the workbook.


I did a search in here but didn't find an answer so here goes nothing...

I have a spreadsheet with data from A1 to H1 down to A275 to H275. I select all of it, Copy, go into the Sheet2 tab and select A1, Paste Special -> Transpose and it give me the following error message:
Quote:

The information cannot be pasted because the Copy area and the paste area are not the same size and shape. Try one of the following:
- Click a single cell, and then paste.
- Select a rectangle that's the same size and shape, and then paste.

For the life of me, I can't figure out why it's not working! I have done this many times with other spreadsheets. Has anyone ever experienced this? If so, were you able to resolve it and how?

Many Thanks,
Mike


I am trying to copy the results of a set of sheets into a new workbook.

When I so this for the first group of cells (about 8 rows by 5 columns) it works fine, then below it I want paste a set of cells exactly the same size. When I try this it says "The information cannot be pasted because the Copy area and the paste area are not the same size and shape". (Excel Mac 2011)

But they are the same size and shape, as the formatting has all been taken from the same source. How can I make it stop giving this error and just paste the stuff in I want anyway? Even if it auto-reformats the cells to fit stuff in.

All I want to do is paste special and put in the values on their own anyway, so it shouldn't make any difference.

Any thoughts?


Greetings,

I am trying to copy and paste 117,000 rows of data from one worksheet to another. The method I use is CTRL+SHIFT+END.

I get the following error:
"The information cannot be pasted because the copy area and the paste area are not the same size and shape" with some lame suggestions.

I know that I can get around this issue by holding shift and then going up/down the entire worksheet, but to do so for 117,000 would be more tedious than watching most of the flashback sequences on Lost.

Any way around this?

Thanks,
Bryce


Word document provide input data which consists of a varyable number of lines
ending with paragraph mark and manual line break. Attepmting to copying the
input data into a merged cell results in "Data on the clipboard is not the
same size and shape as the selected area. Do you want to paste the data
anyway?" On clicking "OK", the paste fails with an error message "cannot
change part of a merged cell".

Can the line endings (including paragraph character) be converted into
Alt-Enter which Excel supports for manually entered multi-line data in single
and merged cells?



Yes, I know the official way to do this..but it's not working.

I select a column in worksheet 1.
I click cell A1 in worksheet 2.
I select Edit>Paste Special, click the Transpose checkbox, and select OK.
I receive this message:
"The information cannot be pasted because the Copy area and the paste area
[dontcha just love the inconsistency in capitalization?] are not the same
size and shape. [of course not--i'm transposing!!] Try one of the following:
"* Click a single cell, and then paste. [which is what I did that didn't work]
"* Select a rectangle that's the same size and shape, and then paste."

Since neither of these worked, the next question is, why the @#$#$ not?

TIA,




"The information cannot be pasted because the Copy area are not the same size and shape. Try one of the following:


-Click a single cell, and then paste

-Select a rectangle that's the same size and shape and then paste"

I need to bypass this message. How?!?

I've tried both of the options given (single cell and rectangle) and neither have worked. I've tried the formatting tool which also give the same error message. Help!


Hello forum,

Using Excel 2003:

A user wants to be able to just copy one cell, and paste it into a selected array of cells elsewhere on the spreadsheet. Essentially cloning a cell using copy/paste.

This works on almost every computer I've tried...of course, except on the one that really matters. In this case, the user gets a message "The data on the clipboard is not the same size and shape as the the selected area"..which, it seems should not matter, because the user wants to copy a single cell onto every cell in the selected area.

The only way I can duplicate this behavior on any other computer is to copy the cell while editing it; apparently so that the cell contents, rather than the cell itself, is put on the clipboard. You can tell when this is the case because the copied cell does not have the Marquee.

If anyone has run into a solution for this, I'm all eyes, thanks. I realize that it might not be the way MS intended the program to be used, but it convenient when it works, and a mystery as to why it works on most computers, but not this one.

Mike


Dear All,

I am in filtered mode and a column cells contains formulae.
while remain in filtered mode and copying all those filtered cell contains formulae and pasting
as value the following error encountered.
The information can not be pasted becoz copying area and paste area not the same size and shape.
Try one of the following:

click on a single celland then paste.
Its to difficult to copy each cell and pasting as value becoz no of cell is more than thousands.

Please can i have any option to overcome this problem ?????


Please assist ?

Rgds,

Aligahk06


I have Excel 2007 SP2. When I try to copy a formula using Ctrl+C and paste using Ctrl+V, only the copied value is pasted. When I copy using Ctrl+C and paste using a right mouse click, it pastes correctly. Also, if I copy using Ctrl+C and drag to the cells I want to calculate, it pastes correctly.

If I copy using Ctrl+C in C1 (having divided A1 by B1) and then select cells C2-C3 and try to paste using Ctrl+V, I get a message that the data on the clipboard is not the same size and shape as the selected area, do you want to paste the data anyway? I say OK and the column headings change from letters to numbers!

I've tried rebooting, repair, reinstallation of Excel, all to no avail. What gives?


Hey all,

If a cell in column O has content, I want to append to bottom of column N. Problem is below VBA throws error "The information cannot be pasted because the copy area and the paste area are not the same shape and size".

Code:

Dim c As Range
Dim Rng As Range
Dim NewRecord As Range

Set Rng = Range("P:P").SpecialCells(xlConstants)
Set NewRecord = Range("O" & Rows.Count).End(xlUp).Offset(1, 0)

If Not Rng Is Nothing Then

    For Each c In Rng
        If c.Row > 1 Then
            c.EntireRow.Copy Destination:=NewRecord
                With NewRecord
                    .Value = .Offset(0, 1).Value
                    .Offset(0, 1).Value = ""
                End With
            c.Value = ""
            
            Set NewRecord = NewRecord.Offset(1, 0)
        End If
    Next c

End If


It's that "EntireRow" part that is causing it. Problem is if I remove it, then if column N contains content in a cell, and O is supposed to paste to that cell, O will not be paste because I dont want to override existing content. I just want to find an existing cell in N that contains nothing and copy there.

Thanks for response.


Hi,
Just installed Office 2010.
When I press PrintScrn or ALT+PrintScrn >> move to an open WB and try to Paste the picture (which is, probably, located in the Comp. Clipboard) into whatever sheet -
I get this error:"Microsoft Excel cannot paste the data".
Pasting into a "Word" Document works like charm.
More than that - when I copy that pasted picture (from inside the document) it "agrees" to be pasted onto the WB Sheet.
Does anybody any clue ?
I am aware that the 2010 is a fresh beta version, "still warm from the oven", but maybe one of you faces a similar problem in one of the previous versions.
Thanks,
Elm


Hi,
I have an Excel file of 1 worksheet, containing data in about 20 rows by 20
columns, which is 310 kB ! I noticed copying the range of cells A3:E7 and
pasting it doubles the file size, but I cannot find anything wrong in those
cells. I tried the following:
1) If I copy all worksheet and paste it in a new worksheet file, the new
file size is the same, > 300kB
2) If I copy and paste all the data column by column, the new file size is
16 kB !
3) If I copy all worksheet and paste values only, the new file size is 14 kB
4) If I delete all the data and the cell formats in the original worksheet,
I still get a large size of > 300 kB !
This is weird. I have nothing in the worksheet, no hidden worksheet, and I
really deleted the rows and columns by selecting them and pressing DELETE.
When I press CTRL-END, the cursor stays at cell A1.

Please help me understand this !

Thanks,
Anik



Recently I upgraded to Excel 2007 and suddenly a lot of my macros involving pictures and pasting no longer worked as I intended. After a little research I discovered that no matter if it's a macro cutting/copying and pasting or I am doing it manually my pictures always resize with the new cell.

What I'm usually trying to do is to move a picture from one cell into another cell in the same workbook or worksheet. I do not want my cells to all be uniform shape, but I want to pictures to be uniform and overlap each other when necessary.

If I have a picture totally contained in one cell where the limits of the picture are shorter than the cell both horizontally and vertically I can copy and paste this picture to a new cell equal to or larger than the parent cell without having my picture distorted (although having "move and size with cell" selected will do the same thing). However, if my picture meets or exceeds the size of the parent cell, or if the destination cell has any dimensions smaller than the picture, that picture will resize to fit the destination cell, even if I have selected the option "move but don't size with cells".

Is there a way to prevent my pictures from shrinking when I paste them into smaller cells (other than manually changing the resized picture back to my desired size or writing code into my macros that re-resizes the picture back to its original size after pasting it)?

I realize that I used the word "size" a lot and that I may have been confusing, so to sum up:

It appears that when I choose the option "move but don't size with cells" (which can be found by right clicking a picture, selecting "size and properties", and clicking on the "properties" tab) the picture reacts no differently from when I select "move and size with cells".

I know I'm not the only one with this problem. I have tried to copy and paste pictures using friends' computers. Anyone with excel 2003 has no problems doing this, but anyone with 2007 has the same problem I do.

I appreciate your input.

Thanks,
CJ


Hey, sorry to bother you for something that's probably obvious, but it's so obvious I can't seem to find the answer by searching...

I am trying to copy a range form one worksheet and paste it into another. Most of the time it works, but every once in a while I get a 1004 error saying that the areas are not the same size and shape so I can't paste.

I can't figure out why, since I am pasting the range to a only the top left cell, and I thought that was always ok. What's up?

Sheets("Phases").Range("B2").Select
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.Copy Destination:=Sheets("summary").Range("A4")

And, yes I know there are too many selects in the above code, but I don't know how to fix it...

Thanks again for any suggestions! I'd understand if it never worked, but when it usually works, it doesn't make sense.

Thanks!


I copy a lot of screen shots on the internet (Firefox) in order to crop them and use them in Excel. ONLY LAST WEEK did I start having this problem. I use the ALT+PRT SCR option to select what's on one monitor (I have dual) and then usually have no problem pasting into Excel. All of a sudden last week I started getting an error message "Microsoft Office Excel cannot paste the data."

I tried clearing out the clipboard in Excel and the ALT+PRT SCR option will either show a black image in the clipboard, or the clipboard will show "item not collected."

Why is this happening just now? I've been running 2007 for more than 6 months...never had a problem until now.


I am trying to delete extra rows at the bottom of my worksheet because they're all empty but they're making the file size huge!

Here are the repro steps:

1. I have two columns in the first worksheet
a. day (mon-sun),
b. date (1-1-07 to 12-31-07)
(these take up 366 rows total)

2. I copied columns A and B and then I went to the second spreadsheet and went to "paste special" > "paste link".

3. Now, that second worksheet has 65536 rows instead of only 366. I tried deleting the extra rows, but it's not working...

How can I get rid of these extra rows?

I'd appreciate any help - these extra rows are killing the file size.


Hello,

I need add 2 shapes to a sheet. The user copy and paste the shapes in to a cells to show a product is complete or still in process. Some users change me the sizes of this shapes by error, can i lock the size of a shape but still give me way move,copy and paste the shape.

Thanks


I am attempting to run write a code that will insert a shape } and size it to the same size as a range. The range will change size every time the macro runs, but will always be vertical. For example, if the range is G10:G20 I want the shape to be the same vertical size, and appear somewhere around column H. Is this even possible? I can figure out how to create the shape, but the sizing issue is beyond me. Hoping someone can help.

James


This happens sporadically. When I have summarized data all by itself or I might have data in say Columns Q thru Z and summarized data in columns A thru J, when I go to set the print area, I get a nasty message:

Margins do not fit page size

And suddenly, every single cell becomes a printable page. I can't seem to be able to set up a proper page size without either having dimensions which don't fit my report or having each cell representing a whole page. Additionally, although this happens only once in awhile, once it happens to a certain sheet or report, it comes up again - even when I copy all the data onto a new page.

Please help!!! Thank you.




Hi,

I'm having some trouble trying to program VBA to paste an Excel table into a PowerPoint slide (I'm using office 2007). I need this to be pasted as a table, not a picture, so that the text size can be edited in Powerpoint to suit.

Essentially, I want to achieve the same result as if you simply paste manually. I can also acheieve the desired result by manually using PasteSpecial and choosing HTML format, however when trying to use the 'PasteSpecial DataType:=ppPasteHTML' method in VBA it does not work and I get the following error message:



Run-time error '-2147188160 (80048240)':

Shapes (unknown member) : Invalid request. Clipboard is empty or contains data which may not be pasted here.





This is the code snippet I am using (pg is the range in Excel that I am copying):



Please Login or Register  to view this content.


Any advice as to how I can resolve this would be much appreciated.

Thank you,

Ryan

Code:

Sub ResizeFont()

Dim rngCell As Range

    For Each rngCell In Worksheets("Project View").Range("Resize_Cells").Cells
        If rngCell.Value = "" Then
            rngCell.Font.Size = 10
        Else
            If rngCell.Value >= 100 And rngCell.Value <= 999 Then
                rngCell.Font.Size = 8
            ElseIf rngCell.Value > 999 Then
                rngCell.Font.Size = 7
            ElseIf rngCell.Value < 100 Then
                rngCell.Font.Size = 10
            Else
                rngCell.Font.Size = 10
            End If
        End If
    Next rngCell
    
'    MsgBox "Size has been fixed"    'Debug message

End Sub


I am getting a Runtime Error 13, Type Mismatch, highlighting If rngCell.Value = "" Then

It runs fine sometimes (when all cells in the range have numerical values), but other times gets that error. Am i using rngCell wrong?


Dear all,

Every time I try to copy and paste using right click on a spreadsheet, the data is pasted but I cannot do anything else unless I press the Enter key. By doing so, the data is pasted once again with all formats. At the bottom of the screen, I get the following message which will not disappear unless I press Enter: Select destination and press Enter or choose Paste.

I think that my coding (which is not linked to any copy and paste action) affects the paste function/clipboard somehow. The first coding is linked to a command button and is about hiding and unhiding certain columns and setting the print area.

The second coding is meant to ensure that all the data entered in certain areas is in uppercase and the second part is to ensure that numbers entered in two different columns are rounded to 2 decimal places.

Here is the coding (kindly provided by far more clever people than me) I have in the workbook:

Code:

Private Sub cmdDerivation_Click()
Static iClicks As Boolean

'Stop screen flickering
Application.ScreenUpdating = False

  iClicks = Not iClicks

  Select Case iClicks
      Case True
          'First Click
          Columns("K:Q").Select
          Range("K10").Activate
          Selection.EntireColumn.Hidden = True
          Range("A1").Select
          Range("A1:J41").Select
          ActiveSheet.PageSetup.PrintArea = "$A$1:$J$41"
          Range("A1").Select
     Case False
          'Second Click
          Columns("J:R").Select
          Selection.EntireColumn.Hidden = False
          Range("A1").Select
          Range("A1:Q41").Select
          ActiveSheet.PageSetup.PrintArea = "$A$1:$Q$41"
          Range("A1").Select
  End Select
End Sub

Private Sub Worksheet_Change(ByVal Target As Range)

'Stop screen flickering
Application.ScreenUpdating = False


'Force uppercase input
On Error Resume Next
If Not (Application.Intersect(Target, Range("E6:I6")) Is Nothing) Then
    With Target
        If Not .HasFormula Then
            .Value = UCase(.Value)
        End If
    End With
End If
On Error Resume Next
If Not (Application.Intersect(Target, Range("E13:Q29")) Is Nothing) Then
    With Target
        If Not .HasFormula Then
            .Value = UCase(.Value)
        End If
    End With
End If

On Error Resume Next
If Not (Application.Intersect(Target, Range("C13:D29")) Is Nothing) Then
    With Target
        If Not .HasFormula Then
            .Value = Format(Round(.Value, 2), "#,###.##")
        End If
    End With
End If

End Sub


The same problem happens whether I use Excel 2003 or 2007 so I don't think it is related to the version of Excel.

Thank you very much for any help that you might provide.

Regards,
Cdmg


Hi

I have column headers in Row 1.
I have a button that should paste approx. 20 rows of external data starting at the next empty row for columns A:I
Upon paste, columns J:T should autofill with formulae for all the newly pasted rows and only the newly pasted rows. Approx 20 rows pasted at a time, but could be less.

This process will be repeated many times so the initial hit of the Paste button will paste for A2:I21, the next paste will paste rows 22-41.

I would also like the columns J:T to be locked once the paste / autofill has occurred.

If the clipboard is empty, an error message would be helpful.

Any assistance... most gratefully received.

Thanks, in advance



I'm perplexed on this one....I'm setting up a sheet as normal in Excel 2002. I choose fit to 1 page wide by one page tall in Page Setup, and I get this error that says "margins do not fit page size". When I click ok, my page fractures into 104 different pages. Anyone know how to fix this, or what's going wrong. My paper size is letter, and my margins are 0.5 in all the way around. Help!!!