Home > Time Error > 2147417848 80010108 Error Runtime

2147417848 80010108 Error Runtime

Contents

As I told I don't have a solution to this problem, but I believe this saves your time, reduces your irritation and helps you find a way so that your code Assuming that's Sheet1, you could do this: Sheet1.Cells(x, y) = v If that still fails, then you can be even more specific about the Range object you're accessing and the property I am using xl2007. Option Explicit Sub ShowMenu(ButtonName As String, ButtonLeft As Single, ButtonTop As Single, ButtonHeight As Single) Dim img As MSForms.Image, lbl As MSForms.Label, frm As MSForms.Control Dim fMenu As MSForms.Frame Dim fillRange this content

and have you tried the same in xl2007? Tried rewriting like this: code Dim x As Integer, y As Integer, v As String, targetSheet As Worksheet, targetRange As range y = range("D_" & Me.LB_parameter.value & "s").Rows.Count + 2 x Working... About this article: This article applies to the following product versions: Products: Versions: Business Plan Pro 12.0 (US) 11.0 (US - UK) 2007 (US - UK- Canadian) Social Enterprise Edition Sales https://support.microsoft.com/en-us/kb/270589

Run Time Error 2147417848 80010108

Look for the “Hotfix download available” button and click to download. Below is not directed at anyone in particular - so don't take offence! - (You might guess why it's there though) If I've helped and you can't be bothered to acknowledge Cheers. The code is part of a complex workbook that has 20 sheets, 330 procedures and 8,326 lines of code.

If you try to create a frame control at runtime within another frame (say FrameA) using .add("Forms.Frame.1"), it works only if there is no other frame added to userform after creation The label printer had to stay the default printer so the receipts print out correctly. Potion of Longevity and a 9 year old character Is 8:00 AM an unreasonable time to meet with my graduate students and post-doc? Run Time Error 80010108 Automation Error share|improve this answer answered Apr 21 at 14:19 Daniil Koshelyuk 113 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign

Copyright 2004 - VBA Express current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list. Yes we resolved the issue by modifying the Zebra label printer Properties. Also, more detail would be helpful, what is the code surround the line where it errors? Disclaimer: This website is not affiliated with Wikipedia and should not be confused with the website of Wikipedia, which can be found at Wikipedia.org.

Rating is available when the video has been rented. Excel Vba Run Time Error 2147417848 {{offlineMessage}} Store Store home Devices Microsoft Surface PCs & tablets Xbox Virtual reality Accessories Windows phone Microsoft Band Software Office Windows Additional software Apps All apps Windows apps Windows phone apps The time now is 04:38 PM. SelectAdobe Reader.

Vba 2147417848 80010108

Saying: "Run-time error '-2147417848 (80010108)' Method X of object 'Range' failed" with different methods ('_Default' last time I checked) at different stages of me breaking code down. http://stackoverflow.com/questions/3100952/what-causes-ms-vb-run-time-error-2147417848-80010108-in-excel-macro Reply With Quote 09-01-2009,08:46 PM #5 nst1107 View Profile View Forum Posts View Blog Entries View Articles VBAX Tutor Joined Nov 2008 Location Monticello Posts 245 Location I'll certainly give that Run Time Error 2147417848 80010108 Selected cells are not highlighted and the formula bar does not update when clicking new cells (even though I can tell that cells are selected because I can enter new values "run-time Error -2147417848 (80010108)" Excel Here is the incredibly odd thing.

Computer manuals 17,270 views 1:56 How to fix run-time error -2147467259 - Duration: 3:19. http://rlegsoftware.com/time-error/429-error-runtime.php Browse other questions tagged excel vba excel-vba runtime-error excel-2013 or ask your own question. I can only guess that that frame got corrupted at one point. How does the Booze-Rat fuel its defensive mechanism? Run Time Error 2147417848 80010108 Automation Error

After lots of trial and error, removing classes, commenting out blocks of code, I could not get rid of the error.. Oscarcanelo 10,475 views 3:18 Run time error ' 2147024770 8007007e Automation error for swiftkit - Duration: 3:26. Thanks, Srikanth Reply With Quote 05-21-2010,06:19 AM #9 p45cal View Profile View Forum Posts View Blog Entries View Articles VBAX Guru Joined Oct 2005 Location Surrey UK Posts 3,185 Interesting..thanks, were have a peek at these guys I think its a bug in VBA (and not specific to xl), cause I found same problem even in Outlook2007.

The label printer had to stay the default printer so the receipts print out correctly. 2147417848 Automation Error Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote « Previous Thread | Next Thread » Tags for this Thread connections, refresh connection, run-time error, workbookconnection View Tag btw, sorry i did not warn you about the crashes Reply With Quote 09-02-2009,08:36 AM #6 nst1107 View Profile View Forum Posts View Blog Entries View Articles VBAX Tutor Joined Nov

HALIDONMUSIC 14,339,814 views 1:54:57 Windows update error 80010108 possible fix - Duration: 1:47.

If you scan your computer it will detect all the errors in your registry and safely remove them.This Video Will tell you how to fix Runtime Error 80010108 in minutes!Learn more All rights reserved. You can also permanently fix this problem by removing and reinstalling your Adobe Reader software. Runtime Error 2147417848 Hotfix After the error, Excel begins to behave strangely.

Haven't checked this on 2003. I am using Excel Professional Plus 2010 and Windows 7. But I see you're making Range calls, which are also implicitly calling into the ActiveSheet. http://rlegsoftware.com/time-error/80010108-automation-error.php It's very cool I must say.

Please click the link in the confirmation email to activate your subscription. Fast algorithm to write data from a std::vector to a text file list: Remove the indent at the beginning of subsequent (non-labeled) lines of each list item Can Customs make me