run-time

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...

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...

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...

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?

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...

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

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 =...

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

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...

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...

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...

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") =...

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...

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 =...

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"...

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...

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...

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...

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:

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...