Cannot COPY & PASTE

[John Eppley]

I am probably doing something very stupid. I have been using EXCEL since
it's inception, and have developed many worksheets and VBA code. I am not a
newbie.

My problem exists with one worksheet, no others. In fact, the problem does
not manifest itself on other worksheets within the workbook. The problem is
this.......

I can select any range of cells, then <EDIT><COPY>, and the appropriate
borders surround the selection and the notification "Select destination
etcetera" appears. But the instant I select any cell or range within the
SAME worksheet I cannot COPY. The border and notification disappears. I can
paste the same selection into any other worksheet within the workbook.

I am embarrassed.............what stupid mistake have I made??????

Thanks for any help.

John

 

[Dave Peterson]

It kind of sounds like there's an event macro (_selectionchange) that's firing.
One of the side effects of running most macros is that the clipboard is cleared.