Can't Paste Without Issues

[Data123]

Hi I have a worksheet that I would like to copy a row from and paste it into another sheet with formulas within the same workbook. When I go to the developer area and click macros I do not see any macros listed, but I may have used one to create the row and then later deleted it. When I do try to paste the row it pastes with different values and formulas compared to the original. I can paste it as values only and it shows just fine. Why is this and how do I fix it please?

Process I have tried. I highlight 50 cells in one row. I use Ctrl-C, then go to a new cell in the same sheet, new sheet or a new workbook and press Ctrl-V. When I do this into a new cell regardless of where it gives me the #REF! in the first cell then #DIV/0 for the rest of the cells. If I highlight 50 cells and try to paste it into there I get the same error results. If I choose values only or links to paste the values are exactly the same as the original.

If a copy and paste the whole sheet into a new sheet it works perfectly.

The formulas in the row of interest do reference another sheet within the same workbook.

 

[Joe4]

Please provide the following information:
1. The exact range address you are trying to copy from
2. The formula in the first cell of the range you are trying to copy from
3. The exact range address you are trying to copy to
4. The formula shown in the first cell of the address you are copying to, after you have pasted it

 

[Data123]

Please provide the following information:
1. The exact range address you are trying to copy from
2. The formula in the first cell of the range you are trying to copy from
3. The exact range address you are trying to copy to
4. The formula shown in the first cell of the address you are copying to, after you have pasted it

1. D2:BA2
2. =('Price Data'!B2-'Price Data'!F2)/'Price Data'!F2*100
3. D2:BA2
4. =('Price Data'!#REF!-'Price Data'!D99)/'Price Data'!D99*100

 

[Joe4]

Based on the formulas you are showing (in 2 and 4 above), that does not seem to line up with the values you placed in the ranges you mentioned.
Are you really copying from D2:BA2 in one sheet, and trying to paste it in the exact same range as another sheet (D2:BA2)?
If so, it should not range your row and column references like that.
Also, when you are pasting it, you should only select one single cell, the first cell in your destination range you wish to paste it to ("BA2").

Lastly, do you have any automated VBA code running in your workbooks (event procedures)?
If so, they could be interfering with things.

 

[Data123]

Based on the formulas you are showing (in 2 and 4 above), that does not seem to line up with the values you placed in the ranges you mentioned.
Are you really copying from D2:BA2 in one sheet, and trying to paste it in the exact same range as another sheet (D2:BA2)?

********Yes.

If so, it should not range your row and column references like that.

Also, when you are pasting it, you should only select one single cell, the first cell in your destination range you wish to paste it to ("BA2").

*****Ah Weird. I just got an error that Excel was running out of memory or something similar. I closed Excel reopened it and it lets me copy and paste now.

Lastly, do you have any automated VBA code running in your workbooks (event procedures)?
If so, they could be interfering with things.

****How do I check to see and if so how to delete?

****May I ask you, I would like to transpose this row in another sheet. I am not able to. Is this normal and if not is there a work around?

 

[Joe4]

****How do I check to see and if so how to delete?

You would need to open up the VB Editor and check all the "Sheet" modules and "ThisWorkbook" module for any VBA code.

****May I ask you, I would like to transpose this row in another sheet. I am not able to. Is this normal and if not is there a work around?

Transpose was not mentioned in your original question at all.
It all depends on what ranges you are trying to copy and where. I am not sure what it would look like if you try copying/transposing formulas.

 

[Data123]

You would need to open up the VB Editor and check all the "Sheet" modules and "ThisWorkbook" module for any VBA code.


Transpose was not mentioned in your original question at all.
It all depends on what ranges you are trying to copy and where. I am not sure what it would look like if you try copying/transposing formulas.

Thanks! I do see several VBA Projects listed. Is there a way to copy and paste the same row mentioned in a transposed format? If not other than deleting the project, which I don't want to do is there a work around?

 

[Joe4]

You only want to look at the VBA Project associated with the workbook you are currently working on.
Then, look at the VBA Modules in it. There should be one called "ThisWorkbook", and then a specific module for each sheet in your workbook.
Is there any VBA code in any of those Modules?

 

[Data123]

You only want to look at the VBA Project associated with the workbook you are currently working on.
Then, look at the VBA Modules in it. There should be one called "ThisWorkbook", and then a specific module for each sheet in your workbook.
Is there any VBA code in any of those Modules?

Thanks, when I click on "ThisWorkbook" and i double click on it and a separate window pop up. If this is where he code goes it's empty no code there.

 

[Joe4]

Thanks, when I click on "ThisWorkbook" and i double click on it and a separate window pop up. If this is where he code goes it's empty no code there.

OK, great.
Is the same true when you click on each of the Sheet modules in that particular project?