paste option
 

Mu paste option is not working
if i make copy for any words, the paste will be HELLO! which i think is the
test word written in the Excel code, i didn't change anything, this problem
suddenly occurs.please advise

Thanks in advance

paste option
 

Hi,
I'm off now, but have just noticed your post & have a suggestion on how
to find where the "test word" of hello is used & clarify what is causing
the problem.

1 In Excel press [alt+F11] (to open the VB Editor),
2[ctrl+r] (to show/select the Project Panel),
3 double click on any of the icons listed under the project with the
name of the current file,
4 press [ctrl+F] (to open find popup), type "hello!" without the
appostrophes, select "current project" & press [enter].

If a popup appears saying "search text is not found", repeat steps 3 &
4 with the other "projects" which appear in your list in the left
panel.
When you find an instance of "hello!", copy a few (four or five) of the
lines of code before, upto, & including where it appears & put them in
a response to this thread (repeat until you have done it for all
instances of "hello!".

Viewing the code should allow someone else to help you out quite
quickly.

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=517220