Thread: Run-time error-2147417848 (8001
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nick Hebb Nick Hebb is offline
external usenet poster
  
Posts: 162
Default Run-time error'-2147417848 (80010108)':
It could be all the Activate's, Select's, and screen updating causing
the memory consumption. The code you wrote could be condensed into:

Application.ScreenUpdating = False
SUWb.Sheets(SUName).Rows(FIRSTROW & ":" & FIRSTROW + nos).Copy
MasterWb.Sheets(Catg).Rows(FIRSTROW & ":" & FIRSTROW).Insert
shift:=xlDown
Application.ScreenUpdating = True

----
Nick Hebb
BreezeTree Software
http://www.breezetree.com

Reply With QuoteReply With Quote