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 -- lunar108 ----------------------------------------------------------------------- lunar1085's Profile: http://www.excelforum.com/member.php...fo&userid=3063 View this thread: http://www.excelforum.com/showthread.php?threadid=50817 |
All times are GMT +1. The time now is 02:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com