Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cannot copy and paste in Excel

Status
Not open for further replies.

DavidBrent

Technical User
Jul 8, 2005
18
GB
Dear All,
I have a very important user that has an annoying problem, every time she highlights the needed cells they very quickly become un-highlighted. and as a result she cannot paste, if she right clicks the option isn't there.

any ideas?

thanks in advance,
David
 


Hi,

Does she have macro code in the Worksheet_SelectionChange event?

Right-Click the Sheet Tab -- select View Code.

Skip,

[glasses] [red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount! [tongue]
 
-> every time she highlights the needed cells they very quickly become un-highlighted.

If the user starts with C3 and highlights down and to, say, G10 - what cell is selected after she releases?

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.
 
Hi Guys,
Yes she has multiple macros in this spread sheet but as i know nothing about them thats all i can tell you!


After she highlights and chooses copy the segmented box appears and then goes quickly althought the area remains highlighted....

hope that helps!?

cheers.
 
without knowing what macros are in there, it's gonna be extremely difficult for anyone to help you.......your call

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
Hey. thanks for you help guys...

i have since found out it is a problem with R3000 xtra and is effecting all our traders.

thanks. David
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top