Auto Filter Paste Error

[eckert1961]

Hello,

I'm running Excel 2003 and I have a workbook with an Auto List in Column G. When I attempt to paste a row of data I get the following message.

The operation is not allowed. the operation is attempting to shift cells in a list on your worksheet.

To work around this, I have to convert the list to a range, copy the data and then reapply the Auto List.

Is there another way to work around this or will I have to create vba code or record a macro?

Thanks,
Chris

[VBA Noob]

I can't be sure from the description but it sounds like you are trying to insert a row which pushes over data off the sheet.

See what your last used cell is by pressing F5 > special > lastcell

VBA Noob

[eckert1961]

Hello VBA Noob,

I did what you suggested and the lastcell is 1 row below the last row of data and 1 column to the right. Not sure what that indicates.

I attached a sample worksheet. If you select a row, copy it and then insert copied cells you will see the error that I noted. The auto list you'll see is in G8.

Chris

[VBA Noob]

The attachment allows me to insert a row manually and by using the macro InsertBlankRow

Have you tried to close the file and reopen it?

VBA Noob

[eckert1961]

Hi Noob,

I have no problem inserting a blank row. The problem occurs when I copy a row with data, such as row 19 and then insert copied rows above row 14 as an example.

In my main workbook I will have to paste rows of new projects from a different workbook into my main one.

For testing purposes I'm doing the copy and paste in the same worksheet.

Chris

[VBA Noob]

Hi Chris,

Again I had no issues. Maybe transfer the info into a new workbook?

VBA Noob