LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default Copy Selection doesn't work

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_

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy Selection - Transpose Selection - Delete Selection Uninvisible Excel Discussion (Misc queries) 2 October 23rd 07 04:18 PM
Why does the Selection not work Sunnyskies Excel Discussion (Misc queries) 2 October 5th 07 07:31 AM
How to make View Fit Selection work? [email protected] Excel Discussion (Misc queries) 1 September 3rd 07 01:28 PM
How do I keep the selection box in the work area Ken Dean Excel Discussion (Misc queries) 2 June 27th 06 09:45 PM
HELP!! Range selection doesn't work pingger Excel Programming 0 July 28th 03 09:24 PM


All times are GMT +1. The time now is 03:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"