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: 1
Default Run Time Error 2147417848 - 80010108 method Copy of Object Range F

Hi

I am running a macro In Excel 2003 Profressional that iteratively opens up a
list of spreadsheets and copies and aggregates the data. I recently started
receiving the Run time Error shown above. The code that blows up is shown
below. What is odd is that
a) it works the first few times
b) it is calling a Macro that works all the time
c) after the error, Excel is totally useless, you can't see the cursor
move,...

PLEASE HELP!!!
Thanks

For R = 1 To rowstoadd
Application.GoTo Reference:="RRcopy_to"
Selection.EntireRow.Insert
Range("RRcopy_from").Copy <==== ERROR <====
ActiveSheet.Paste
Next R
 
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
Runtime Error '-2147417848 (80010108)' Ian Excel Programming 3 February 19th 07 02:22 PM
Macro does not work after the program has been restarted in excel.Run time error 2147417848 (80010108) Method visible of object_worksheet failed [email protected] Excel Programming 7 August 24th 05 03:11 PM
Excel Bug: Run-time error '-2147417848 (80010108)' majikman[_18_] Excel Programming 1 May 13th 04 08:16 PM
Automation error -2147417848 (80010108) mbobro[_5_] Excel Programming 2 April 8th 04 01:10 PM
Run time error 2147417848(80010108) Praveen Excel Programming 4 December 18th 03 10:23 AM


All times are GMT +1. The time now is 12:32 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"