runtime error

  1. D

    Am I adding a potential error in VBA by renaming a Sheet name in properties? (run-time error -21473219767 (80028029))

    Today I ran into the Run-time error -21473219767 (80028029) Automation error. Invalid forward reference, or reference to uncompiled type. Like others, I had been running my code for years without issue. Today, it decided to not function as it had before. After reading a bit from other posts, I...
  2. A

    Please help with my runtime error '424' object required

    Here is my code: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$E$70" Then If Me.Range("E70") = "Yes" Then If Me.Range("E9") = "" Then MsgBox "Please enter school ID at the start of the form to continue"...
  3. thelukeee

    Importing .Txt files based on date last modified, then sort file by Comma Separation (VBA)---Error: "Run-time error '76: Path not Found"

    Hello everyone, I'd appreciate some coding help in Excel using VBA. I'm very new to this. Background: There is a new .txt file made for each machine run, which contains details about the part and the weight gain. The .txt file is created automatically in the system, and goes unedited by...
  4. 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...
  5. 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)...
  6. 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...
  7. 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...
  8. 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 = ""...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top