Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with Macros - ActiveSheet.Paste
I wrote a macros that copies data from a worksheet, creates a ne worksheet, assigns a name to it and pastes the copied data, but now i failing when pasting. It does paste 2 lines of data and then quits. My macros is giving out an error Run-Time-error: Method 'Paste' o Object '_worksheet failed' What is strange is that it was running right then started failing. can you help? I appreciate your hel +------------------------------------------------------------------- |Filename: Sub MainSubDue.doc |Download: http://www.excelforum.com/attachment.php?postid=4311 +------------------------------------------------------------------- -- lunar108 ----------------------------------------------------------------------- lunar1085's Profile: http://www.excelforum.com/member.php...fo&userid=3063 View this thread: http://www.excelforum.com/showthread.php?threadid=50817 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with Macros - ActiveSheet.Paste
I to have resently had the same problem
I fixed it by inserting the command for each sheet it was going to to copy andf then paste May not work for you like but its worth a try -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Working with Macros - ActiveSheet.Paste | Excel Programming | |||
Working with Macros-Activesheet.Paste | Excel Discussion (Misc queries) | |||
ActiveSheet.HPageBreaks not working | Excel Programming | |||
Paste Method failed (Activesheet.Paste) | Excel Programming | |||
ACTIVESHEET.PASTE not working. | Excel Programming |