VB coding for complete cell copy rather than what ^C does?

[StargateFan]

This is a weird situation, if I go into a cell and press ^+C, I get
one type of output from the clipboard in a particular sheet I'm
working on. But this output is not correctly formatted in many
cases. If I go into the cell then press F2 and select the text
manually, I get the complete text. I have never seen this before so
don't know what it means.

In any event, is there some vb code out there that will mimic
selecting the cell contents manually? I can then attach that to
keystroke so no more worries. This manual process is slowing me down
considerably.

Thanks.

 

[Don Guillett Excel MVP]

This is a weird situation, if I go into a cell and press ^+C, I get
one type of output from the clipboard in a particular sheet I'm
working on.  But this output is not correctly formatted in many
cases.  If I go into the cell then press F2 and select the text
manually, I get the complete text.  I have never seen this before so
don't know what it means.

In any event, is there some vb code out there that will mimic
selecting the cell contents manually?  I can then attach that to
keystroke so no more worries.  This manual process is slowing me down
considerably.

Thanks.  

If you looik at the edit>copy menu you will see that that is the same
as ctrl+c????
Examples?
"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."

 

[StargateFan]

Don, hi.

Selecting the text manually then pressing ^+C does not always give the
same results as when you press ^+C directly on just the selected cell
in this particular sheet. I don't know why. I suspect their funky
characters in the txt _might_ have something to do with it but I don't
know. I am to copy the text, that's all I know <g>.

What I need to learn is how to automate the selecting of the text
rather than manually going F2, going to beginning of cell contents,
then selecting the entire text, _then_ pressing ^+C. Just need to
know if there is vb code that will do that vs. just EDIT > COPY (or
whatever it is with this darned ribbon in Excel 2007! <g>).

Thanks. D