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
|