Thread: paste option
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
broro183
 
Posts: n/a
Default 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