Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
(Error 1004) Object Defined Error ...simple code | Excel Programming | |||
copy and insert throwing error- help in code req | Excel Discussion (Misc queries) | |||
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) | Excel Programming | |||
Code to copy range vs Copy Entire Worksheet - can't figure it out | Excel Programming |