Cannot COPY then PASTE

[John Eppley]

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]

You've gotten responses to a couple of your previous posts.

Did they work when you looked at them?

 

[John Eppley]

Negative.......This is the FIRST reply to ANY of my three posts is three
different newsgroups. I have yet to see any of my posts. I have contacted my
internet provider this morning about the problem.

You are my first contact of any type.

John

 

[Dave Peterson]

You can use google to search for posts you've authored--and for replies:

http://groups.google.com/advanced_group_search

I searched the *excel* newsgroup between Jan 1 and today with your name as the
author and found these:

http://groups.google.com/groups?as_...007&as_maxd=9&as_maxm=3&as_maxy=2007&safe=off

or

http://snipurl.com/1cjux

 

[John Eppley]

Thanks to Dave and Jim. I found a piece of code "event handler" that was
causing the problem. The original VBA code dates from Aug 1999. Recent
additions to the program finally executed the event handler. I guess at the
age of 72, the mind is the second thing to go.

BTW, I still have not seen any of my three original posts. Very confusing.

John

 

[David McRitchie]

Hi John,
The usual problem of not connecting directly to the
news servers at Microsoft is that you won't see the messages
come up in the order that they were submitted though the threads
will show them correctly threaded once received. Less common
is what you experienced is where the only messages you might see
are those submitted by other RR subscribers for a period of time
or some message may be lost forever. Both newsgroups you
posted to have a lot of traffic so that is not a problem.

If I look in your headers, I see that you are not connected
directly to the Microsoft news servers:

Path:
TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS02.phx.gbl!news-out.cwix.com!newsfeed.cwix.com!newscon02.news.prodigy.net!prodigy.net!nx01.iad01.ne
wshosting.com!newshosting.com!post01.iad01!roadrunner.com!not-for-mail

I see 8 hops (! marks) from one server to another

In Dave Peterson's there is only one and that is between
Microsoft servers and perfectly normal.

Path: TK2MSFTNGP01.phx.gbl!TK2MSFTNGP06.phx.gbl

To connect directly to Microsoft news servers in Outlook Express:
http://www.mvps.org/dmcritchie/ie/oe6nws01.htm

You will only find microsoft newsgroups hosted at
msnews.microsoft.com

 

[John Eppley]

I tried posting to two DIFFERENT and separate accounts. None of my original
postings have shown up on any of the three newsgroups.

Replies to my postings have shown up on the duplicate accounts of
Microsoft.Public.Excel.

Confusing

 

[Dave Peterson]

Take a look at David McRitchie's link:

To connect directly to Microsoft news servers in Outlook Express:
http://www.mvps.org/dmcritchie/ie/oe6nws01.htm

You'll find that if you want to hang around the newsgroups--either posting or
just lurking, it'll be much easier.

Saved from a previous post:

If you have Outlook Express installed, try clicking on these links (or copy and
paste into MSIE).

news://msnews.microsoft.com/microsoft.public.excel.setup
news://msnews.microsoft.com/microsoft.public.excel.misc
news://msnews.microsoft.com/microsoft.public.excel.worksheet.functions
news://msnews.microsoft.com/microsoft.public.excel.newusers
news://msnews.microsoft.com/microsoft.public.excel.programming

(and a few more for MSWord)
news://msnews.microsoft.com/microsoft.public.word.docmanagement
news://msnews.microsoft.com/microsoft.public.word.word97vba
news://msnews.microsoft.com/microsoft.public.word.newusers
news://msnews.microsoft.com/microsoft.public.word.pagelayout
news://msnews.microsoft.com/microsoft.public.word.vba.addins
news://msnews.microsoft.com/microsoft.public.word.vba.beginners
news://msnews.microsoft.com/microsoft.public.word.vba.customization
news://msnews.microsoft.com/microsoft.public.word.vba.general
news://msnews.microsoft.com/microsoft.public.word.vba.userforms
news://msnews.microsoft.com/microsoft.public.word.word6-7macros

(You can always connect to more later)

Here are some links that explain it better:

Chip Pearson has some notes written by Leonard Meads at:
http://www.cpearson.com/excel/DirectConnect.htm

David McRitchie's notes at:
http://www.mvps.org/dmcritchie/excel/xlnews.htm
http://www.mvps.org/dmcritchie/excel/oe6.htm
http://www.mvps.org/dmcritchie/excel/oe6nws01.htm

Tushar Mehta's notes at:
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.htm

And if you're looking for old posts:

Or you can use google (maybe a few hours behind) to search for stuff you've
posted (and find the replies, too)

http://groups.google.com/advanced_group_search
http://groups.google.com/advanced_group_search?q=group:*Excel*&num=100

Ron de Bruin has an excel addin that you may like:
http://www.rondebruin.nl/Google.htm

 

[David McRitchie]

Hi John,
The usual problem of not connecting directly to the
news servers at Microsoft is that you won't see the messages
come up in the order that they were submitted though the threads
will show them correctly threaded once received. Less common
is what you experienced is where the only messages you might see
are those submitted by other RR subscribers for a period of time
or some message may be lost forever. Checking Google Groups
with yourself as the author is a good idea if you don't see replies
coming in after a day just to make sure that it's not your connection.

If I look in your headers, I see that you are not connected
directly to the Microsoft news servers:

Path:
TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS02.phx.gbl!news-out.cwix.com!newsfeed.cwix.com!newscon02.news.prodigy.net!prodigy.net!nx01.iad01.ne
wshosting.com!newshosting.com!post01.iad01!roadrunner.com!not-for-mail

I see 8 hops (! marks) from one server to another

In Dave Peterson's there is only one and that is between
Microsoft servers and perfectly normal.

Path: TK2MSFTNGP01.phx.gbl!TK2MSFTNGP06.phx.gbl

To connect directly to Microsoft news servers in Outlook Express:
http://www.mvps.org/dmcritchie/ie/oe6nws01.htm

You will only find microsoft newsgroups hosted at
msnews.microsoft.com

 

[David McRitchie]

Sorry for duplicate reply, looked like it was on statusbar
and not sent.

 

[Jack]

You must be the old-timer, aren't you?
Jack