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

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

Did they work when you looked at them?


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

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

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_q...=2007&safe=off

or

http://snipurl.com/1cjux



John Eppley wrote:
>
> 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

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

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
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"John Eppley" <(E-Mail Removed)> wrote in message news:%237%(E-Mail Removed)...
> 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
>
>

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

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/microsof...ic.excel.setup
news://msnews.microsoft.com/microsoft.public.excel.misc
news://msnews.microsoft.com/microsof...heet.functions
news://msnews.microsoft.com/microsof...excel.newusers
news://msnews.microsoft.com/microsof...el.programming

(and a few more for MSWord)
news://msnews.microsoft.com/microsof....docmanagement
news://msnews.microsoft.com/microsof...word.word97vba
news://msnews.microsoft.com/microsof....word.newusers
news://msnews.microsoft.com/microsof...ord.pagelayout
news://msnews.microsoft.com/microsof...ord.vba.addins
news://msnews.microsoft.com/microsof....vba.beginners
news://msnews.microsoft.com/microsof....customization
news://msnews.microsoft.com/microsof...rd.vba.general
news://msnews.microsoft.com/microsof....vba.userforms
news://msnews.microsoft.com/microsof....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_tut...e_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_gr...Excel*&num=100

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

John Eppley wrote:
>
> 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

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
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"John Eppley" <(E-Mail Removed)> wrote in message news:%237%(E-Mail Removed)...
> 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
>
>

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