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