PC Review


Reply
Thread Tools Rate Thread

Copy Selection doesn't work

 
 
nxqviet
Guest
Posts: n/a
 
      17th Aug 2007
Hi all,

I have a macro that contains this following code. This is a very basic
copy code that copy a selection in Excel and Pates it to an opened
MS.Word application at a specified bookmark. This very long macro
works fine 80% of the time, but once in a while, the script would just
skip right over the Selection.copy part and then promt an error at the
Pates part, since the clipboard is indeed empty....

Application.Goto ("RangeA")
Range("RangeA").Select
Selection.Copy
WRD.Selection.Goto what:=wdGoToBookmark, Name:="BMarkA"
WRD.Selection.Paste

When debugging the error, i see that RangeA was selected, but never
copied (no flashing border around it). Then, I would just drag the
Yellow Arror back to the Application.Goto part, and make it repeat the
script, it would work fine. This error only happen once in a while, I
don't understand. Could it be the code? Could it be the memory? Please
help.

Thank you very much for you time and your help,

V_

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
filter by selection doesn't work vicki.wells@modot.mo.gov Microsoft Access Queries 0 6th Apr 2009 04:03 PM
Filter by selection doesn't work vicki.wells@modot.mo.gov Microsoft Access Forms 0 6th Apr 2009 03:08 PM
Filter By Selection : Doesn't always work Sarah Microsoft Access 0 7th Dec 2007 04:31 PM
Print selection doesn't work in IE6 =?Utf-8?B?V0FV?= Windows XP Internet Explorer 1 29th Aug 2004 02:02 PM
HELP!! Range selection doesn't work pingger Microsoft Excel Programming 0 28th Jul 2003 09:24 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:49 PM.