runtime error

  1. A

    Method Clear Contents of Object Range Failed

    Hi I have the following simple code, never had an issue with it before but all of a sudden I am getting the "Method Clear Contents of Object Range Failed" run time error. From what I have read this isnt so much an error with the code but more to do with the system is that correct? If anyone...
  2. S

    RunTime Error 462 while converting word docx to PDF

    '******* EmpFolder is a Global Variable containing Folder Path ************************* Sub BatchConvertDocxToPDF() Dim objDoc1 As Document Dim strFile As String, strFolder As String 'Initialization strFolder = EmpFolder & "" strFile = Dir(strFolder & "*.docx", vbNormal)...
  3. K

    vbs script suddenly started "unknown runtime error" on running macro in excel - any ideas??

    My script was running just fine up until about a week ago. Now it throws an error on the macro run statement. The macro runs fine in the spreadsheet when run manually. We did run windows updates, and an antivirus update; but that should not have changed anything in this - right? I'm running...
  4. C

    VBA Internet Controls Macro Running Slow and Stopping at the 242nd Number In List

    I have written a macro that pulls numbers from a long list and inputs them into a website. After looping through about the 25th number, it seems to start noticeably slowing down more and more. It also seems to crash at 242 numbers and displays 'Run-time Error -2147319783: Automation Error. Old...
  5. B

    Runtime Error '1004'

    I keep getting the following error and I don't know why: Runtime Error '1004': Method range of object global Failed Here is my code with the line causing the issue denoted with the *. Sub Button1_Click()ActiveSheet.Range("AL2:AL399").Value = 0 ActiveSheet.Range("BH2:BP399").Value = ""...
  6. T

    VBA - run time error '13' type mismatch selecting sheet based on named range

    Hi everyone, Please can someone help me with the following, apologies if this is quite basic. I've not done any VBA for a long time and I'm out of practice. In my Excel workbook I have a number of buttons to take you to different sheets in the model, I'm trying to write code that can be...
  7. A

    Calling a macro when activating a sheet

    Hi all! When I activate a Sheet A, I want to run a macro which does something on another Sheet B, including copy and paste some ranges on sheet B. The macro runs well independently. However, when I put it in the event of activating Sheet A, the following error occurs: Runtime Error...
  8. I

    Runtime error Out of Memory

    Beginner VBA user here. I'm getting a runtime error that says "Out of Memory" with one certain set of code. I have one specific worksheet within a workbook that contains 4 rows each valued as the days Monday, Tuesday, Wednesday, Thursday respectively in Column "A". The nature of the worksheet...
  9. I

    Run-Time error 1004 when clearing cells

    I'm scanning ID & Username into "column A1" the vba then moves the cursor to the right to "column b" finally down to "A2,B2,etc.... But if I make an error of some sort and click on the cell to delete the ID or Username this Run-time error '1004': Application-defined or object-defined error...
  10. T

    Run-time error 2147024894

    Hello, Hoping someone can help me with this. I am attempting to run a script from Excel that saves an exported report from SAP in a given location. This code runs without issue on several computers. When I emailed the code to a coworker they kept getting this error: Run-time error '-2147024894...
  11. Rlhoffarthexcel

    Macro created in PC Excel returns Run-time error 448 when run in Mac Excel

    I have a very frustrating Macro issue: A pair of macros that were created in Excel for PC won't run properly on my Excel for Mac. And, yes, I've "enabled Macros" on my Mac whenever I pull up Excel files that have Macros. BACKGROUND: I run a MacPro, 16 gigs RAM, 1TB SSD. I run Parallels for...
  12. M

    Run time error

    Hi Folks, I am running a code that I use everyday without fault , nothing has changed but I am getting a run time error which has dwindle my motivation to fix it. here is the vba script with the error highlighted. Public Sub ROCSORT() TotalRowsROC = Worksheets("ROC").UsedRange.Rows.Count...
  13. J

    Can't add new controls to userform. Run-time error '-2147352573 (80020003)'

    Hello all, First off I'm really new to excel and vba so bare with me I've always been able to solve whatever problems I encounter, searching forum and melting my brain, but this one is way out of my reach and I don't seem to find nothing in the forums that clearly solves the problem. I'm...
  14. A

    runtime error 2110

    Still new with VBA, using only what i have learned online and on these forums lol. I have created a multipage userform in excel. i entered a code to set focus on blank text before moving on to the next page when clicking "next" however i keep getting Run-time error '2110' "Cant move focus to...
  15. X

    Run Time Error 13

    Hi, I inherited a macro & it has worked in previous months but this month I am getting the data type mismatch error. I've done some digging & understand that is telling me its an unrecognized data type but I wanted to post the code to see if anyone sees somenthin obvious...theres a ton more code...
  16. K

    For Each loop with Dim as Long - Run-time error '6' Overflow

    Hi all I'm struggling a bit with a Run-time error '6' Overflow. My code is only able to handle 32.767 cells so I assume the reason is a default Dim As Integer. If so I guees I only need to have Dim changed to Long but for some reason I can figure out how to do this in my For Each loop. And as...
  17. T

    Dynamic Range error When Multiple Workbooks Open

    In the attached spreadheet, I have a dynamic range defined which populates a dropdown https://dl.dropboxusercontent.com/u/63479593/Enterprise%20Release%20Project%20Dashboard.xlsm Dynamic Range Is =OFFSET(Projects!$C$1,1,0,COUNTIF(Projects!$C:$C,">""")-1,2) This populates a drop down in the...
  18. S

    Error 800A9C68 running VBS using task scheduler

    Hello, I keep getting this windows script host error. Script: C\top 5 macro.vbs Line: 5 Char: 1 Error: Unknown runtime error Code: 800A9C68 Source: Microsoft VBScript runtime error Dim xlApp Dim xlBook Set xlApp = CreateObject("Excel.Application") Set xlBook =...
  19. bs0d

    VBA ADO Query Run-time Error: System Resources Exceeded

    I'm running an ADO query through Excel to insert up to 50k rows into a table. The query uses dSUM to get a running total for items by date, so it's likely that it is "calculation heavy". Even running directly in Access, it takes a moment to complete. When running it in Excel however, I get the...
  20. D

    Macro error interfacing with SAP after Window 7 Update

    I've created a macro that opens SAP, and downloads a number of different reports. It was working fine last week, but after an update to Windows 7 from xp (and excel 2007 to 2010), I now receive the following error during a loop in my code: Run-time error '619' The control could not be found by...

Some videos you may like

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top