Cannot COPY then PASTE
 

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

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

Cannot COPY then PASTE
 

The response at the other thread didn't help???

John Eppley wrote:

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

--

Dave Peterson