View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Cannot COPY then PASTE

Right click on the worksheet tab and select View Code. See if there is any
code in the Worksheet_SelectionChange event handler (or any other if not).

Jim

"John Eppley" wrote in message
...
Repost from another newsgroup

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