run-time

  1. G

    help me ))) run-time error '-2147012894 (80072ee2)':

    What is the cause of this error? run-time error '-2147012894 (80072ee2)': the operationg timed out With httpReq .Open "GET", matchURL, False .setRequestHeader "Host", "www.xxx.com" .setRequestHeader "User-Agent", "Mozilla/5.0 (Windows NT 10.0; WOW64...
  2. Z

    wait after workbook is saved

    hi, I need to refresh Query (PQ) after file saving. Is there any way to check if is fully saved before executing next line? In below code if any user would switch sheets very quickly I get run-time error. Private Sub Worksheet_Activate() ActiveWorkbook.Save ActiveWorkbook.Connections("Query...
  3. R

    Run-time error code when initiating userform

    I'm trying to retrieve a cell's value to display in a userform text field. Private Sub UserForm_Initialize() Call GetData End Sub Private Sub GetData() Dim r As Long r = Cells(ActiveCell.Row, 78).Value PMField.Text = Worksheets("GhostData").Cells(r, 132).Value End...
  4. A

    Run-time error

    TextBox11 = TextBox9.Value - TextBox10.Value Hello, If there is no data at one of the textboxes I'm having an error as Run-time error '13': Type mismatch What is the solution to fix that problem?
  5. A

    Vba Vlookup from userform textbox entry - run-time error 424

    Trying to pull in an email address from a textbox on a userform. Worksheet is called DATA names are listed in column O2:O30 email addresses are listed in P2:P30 ENG = UserForm1.ComboBox2.Value ' Eng Dim EMAIL As String EMAIL = Application.WorksheetFunction.VLookup(ENG...
  6. B

    Run-Time error

    receiving a run-time error on some provide vba code not sure why? Active X Component can't create object. Any help would be appreciated. Thanks
  7. J

    Run-time error 13

    hi, I have this table and the code below but when run it get run-time error 13 mismatch, please help. <tbody> Customer Contact A/C Date Due Date Days Inv# $ Due in days Email </tbody> ***Note: due date is column "F" Sub popup() Dim lstRow As Long Dim i As Long Dim msg As String msg =...
  8. J

    How to Fix Run-time error 9

    I am trying to make a macro that creates a worksheet for each month of a year, with the user typing in the year. When I run the macro, I keep getting Run-time error 9 on this line of code about adjusting the column width: Worksheets(MonthName(monthNum, True)).Range("A5:K5").ColumnWidth=15
  9. B

    Run-time error 91 - object variable or with block variable not set

    Hi everyone, I'm trying to troubleshoot a run-time error 91 on a macro in my workbook. Essentially this macro looks through active worksheets to find any issues (special formatted cells in active worksheets) and returns the comments in these formatted cells in a 'issue worksheet' (I hope that...
  10. U

    Macro Run-Time Error

    Hello, I'm hoping someone can help me out with an error I'm receiving when I run my macro. I have a macro that will copy the active sheet then paste it to a new worksheet and at the same time it will name the new tab based on the value in cell B3. The problem I'm having is when I run the macro...
  11. K

    Run-time error '-2147024809 (80070057)' : item with the specified name wasn't found

    Hello i have a sheet run well on Excel 1997 version. When I run it on Excel 2003 version i have this message error: Run-time error '-2147024809 (80070057)' : item with the specified name wasn't found pls, can you help me : my peace of code is below: Sheets("Pz1").Select...
  12. T

    Calling Value from Closed Workbook

    Is there any way to call a cell's value from an external workbook without the need to have the source workbook opened? For instance the below code throwing "Run-time error '9': Subscript out of range". Workbooks("wb1.xlsx").Sheets("Sheet1").Range("A1") =...
  13. F

    Error run-time 13 with VBA - Excel

    Hi everybody, I am trying to run the following coding in the macro: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 4 And Target.Row = 2 And Target.Value = "5" Then Application.Columns("L:P").Select Application.Selection.EntireColumn.Hidden = True...
  14. L

    VBA Run-Time Error '1004' Help!

    Good morning all, I have come across 'Run-time error '1004': - Method 'SaveAs' of object '_Workbook' failed. The code is below. Any help would be greatly appreciated. Many thanks, Sub SaveAsPDFExcel() Dim fName As String Dim sLoc As String 'location sLoc =...
  15. J

    Run-time error 1004

    Hi all I have a workbook, where when opened, I need to log the user, date and time of opening, and then save the event. The event is written to a sheet hidden from the user named "User_Data" Simple 2 lines of code to achieve this:- Sub Workbook_Open() Sheets("User_Date").Range("A"...
  16. D

    Run-time error '9': Subscript out of range on Copy/Paste VBA?

    Hi Folks, I have this copy/paste VBA which copies a range from one workbook into another workbook. Public Sub CopyPaste() Workbooks("GenericGRNReport(Excel2010).xlsm").Sheets("GRN_Data").Range("$E$3:$F$5000").Copy...
  17. G

    Run-time error '13: Type Mismatch

    I am trying to do a dynamic "Hide Rows" function where if a certain cell in a row has any value a number "1" will populate the A cell of that row, an example would be if cell B11 has value A11 will be equal to "1"... What I had the macro doing was hiding all rows where A = "" The code had been...
  18. Y

    Run-time error: Methods 'add' of object 'SlicerCaches' failed

    Hi All, The method SlicerCaches.Add() worked in Excel2010 but not in Excel2016. So i tried SlicerCaches.Add2() in Excel2016 and got the same error message: Run-time error: Methods 'add2' of object 'SlicerCaches' fail. I dim SC as Slicercache then add slicers to it. i tried to record macro then...
  19. S

    run-time error 424 object required

    hi friends, i create the code. automate send the wishes in outlook but i getting error run-time error 424 object required. please give me solution or any idea thanks:confused::confused:
  20. jakeman

    Run-time error 1004: Unable to set the FormulaArray property of the Range class

    Hey, guys - I have a line of VBA that's giving me trouble and I'm not sure how to solve for it. I have several lines of code that create formulas for me inside of my table and they all work fine. When I tried to do the same using an array formula, I get an error: "Run-time error 1004: Unable...

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
Back
Top