Copying and pasting a long row has issues

[nachobear]

Hi

Wanted to see why I can't properly paste an entire row on cells like a few weeks worth from online excel to a die loaded excel file

The copy part isn't the issue only the paste part

And I think the message I get is

The data your pasting isn't the sane size as your selection. Do you want to paste this anyways?

This is related to my last post in a way that, but that post is answered.

Just that when I paste them I don't paste all the items that I have copied.

It only lets me copy and paste within a week, that's when there's no issues but when it's going pass the five days then the message pops up

 

[Asbestos_Jen]

There's probably a VBA solution, but I would just unhide all of the hidden columns (select all and then right-click on a column header and choose unhide), then manually select columns with weekend dates and right-click delete them.
ETA: Given that I don't have all of the information about your spreadsheet, I suggest you try it out on a COPY of your workbook, as deleting cells will affect any cells dependent on them, and you could end up with a lot of #REF errors.

 

[nachobear]

There's probably a VBA solution, but I would just unhide all of the hidden columns (select all and then right-click on a column header and choose unhide), then manually select columns with weekend dates and right-click delete them.
ETA: Given that I don't have all of the information about your spreadsheet, I suggest you try it out on a COPY of your workbook, as deleting cells will affect any cells dependent on them, and you could end up with a lot of #REF errors.

Good idea on the copy the file

I can't even delete the columns i get this message

 

[Asbestos_Jen]

What does your selected area look like? You should be selecting whole columns (like below), not groups of cells.

 

[nachobear]

What does your selected area look like? You should be selecting whole columns (like below), not groups of cells.

View attachment 107873

this is what the screen looks like

 

[Asbestos_Jen]

Are some of the cells in those columns merged? That could be part of the issue, but I'm not sure as your error message indicates an array is involved. That could be something new in Excel 365 (relative to 2007, anyway, which is what I'm using ).

 

[nachobear]

Are some of the cells in those columns merged? That could be part of the issue, but I'm not sure as your error message indicates an array is involved. That could be something new in Excel 365 (relative to 2007, anyway, which is what I'm using ).

how can i find out if its merged?

 

[Asbestos_Jen]

Can you use the XL2BB tool to show your destination worksheet? XL2BB - Excel Range to BBCode I think I need more information. A quick google said that the cells targetted for deletion may be in use as part of an array formula. If so, deleting those cells will lead to a bunch of errors.

 

[nachobear]

gives me this message

 

[MARK858]

@nachobear, see the link in the the note in the XL2BB instructions....

Note:
If you have difficulties installing the add-in, please take a look at this amazing article from Jon Peltier - Install an Excel Add-in.

 

[nachobear]

i clicked ok to the option to unblock

then that option disappear when i went into properties again and its showing the macros message