It sounds like you have code running, it may be contained in teh
worksheet calculate, change or selectionchange event, to find it right
click on your worksheet tab and choose View Code and see whats there
that may be interfering with your paste, if there is nothing there it
may be in the ThisWorkbook module, to see that press Alt+F11 then double
click Thisworkbook on the left hand side.

Stanley Braverman;246461 Wrote:
I have a very strange problem. When I go to a cell and right click and
select insert cell I get the dialog box that selects second option
"shift
cells down" and it works correctly. But not again for 10 minutes? What
I
get instead is dialog box with first option selected and when I select
second option "shift cells down" I get pop up box with error message
"To
prevent possible loss of data etc,etc, etc." However after several very
long minutes it will work correctly once and then have to wait again??

Using Excel 2002


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=68794