LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 536
Default Code does not error but no copy either

On Tuesday, July 16, 2013 1:03:30 AM UTC-7, Claus Busch wrote:
Hi Howard,



Am Tue, 16 Jul 2013 00:59:33 -0700 (PDT) schrieb Howard:



Much cleaner.




but does it work?





Regards

Claus B.

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2


Yes, indeed, works fine. However, it had a subscript out of range error and that lead me to investigate and see that my original code was actually working except I have Book2 as the copy TO and It should have been Book3.

So it would copy back to the same sheet as the copy FROM, while all the time I was looking at book3 for the results and not getting any.

You can fix code, but you can't fix stupid.<g

Thanks Claus.

Regards,
Howard






 
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
(Error 1004) Object Defined Error ...simple code Robert Crandal Excel Programming 1 January 12th 10 10:31 PM
copy and insert throwing error- help in code req dee Excel Discussion (Misc queries) 8 March 6th 08 09:57 PM
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... Corey Excel Programming 4 November 25th 06 04:57 AM
Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) Tim[_36_] Excel Programming 4 April 23rd 04 02:53 AM
Code to copy range vs Copy Entire Worksheet - can't figure it out Mike Taylor Excel Programming 1 April 15th 04 08:34 PM


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

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"