run-time

  1. S

    Run-time error '1004'

    I have a monthly report which has a macro that combines data from two sources automatically and updates several pivot tables. This report used to work flawless on ex coworkers computer. He sent me the report and now I cannot make it work. I receive below error: Run-time error '1004' : We...
  2. ExcelNovice

    Running multiple macros with one command button on userform

    Hi, I'm trying to run the following macros from a userform but continues to get an error each time I try: Private Sub CommandButton1_click() Call Worksheets("Sheet1").CommandButton11_click Call Worksheets("Sheet1").CommandButton12_click Call Worksheets("Sheet1").CommandButton13_click Call...
  3. J

    Run-time 13 error

    Afternoon all!! I have a baseball spreadsheet that has been working up until a couple of days ago. Something weird started happening when the 3rd out happens and it goes to the sub "currinning". I get a Run-time 13 error everytime the Call to currinning happens. No matter what type of out...
  4. T

    Run-time error '1004' help. Thank you

    Hi all, I'm attempting to write a macro that puts data into a pivottable automatically. This seems pretty simple, but I can't quite figure it out. I think there is a problem with the name of the table and location its going to? I'm not to sure. I'm getting the Run-time error '1004'...
  5. A

    Run-Time Error 3706 Provider Cannot be Found

    I am trying to Sync a file to my Excel workbook and getting this error message. I am still very much a novice and have a lot to learn. Not really sure how to go about fixing it. Can anyone please explain and help with this problem...
  6. D

    Run-time 9 Error

    For the life of my I cannot figure out why the following line of code is giving me a "Run-time error '9': Subscript out of range" Error. Workbooks("Lookup").Worksheets("Sheet1").Range("A1:BK2000").Copy Destination:=Workbooks("EstimateChecker").Worksheets("estsheet").Range("A1:BK2000") I am...
  7. B

    Run-time error 57121 HELP

    I have created this macro and it works fine on my computer. However, I sent it to coworkers to use on their computers and it does not work. Private Sub Workbook_Open() ' ' MoveDateBoxMain Macro ' ' Sheets("Main").Activate ActiveSheet.Shapes.Range(Array("DTPicker2")).Select...
  8. J

    Run-time error 1004

    Getting this run-time error 1004 and when go debug highlight the the following line of code: ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=PDFFile, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _ :=False, OpenAfterPublish:=OpenPDFAfterCreating...
  9. Z

    Run-time error 438

    Hi, I have a macro that build PowerPoint presentation from excel. And workbook that has several tabs and their names as below: "It would take", "Themes_2", "Themes_1". When I tried to build the slides this is what happened: "It would take" tab successfully built into .pptx but the rest of the...
  10. D

    Run-time erroe 13 type mismatch

    I have a problem with an exel file. I work in a company and we use a file to analyze employee performance. When I open the file and enter the parameters of the day and time to see the productivity, exel reworks the file (connecting to an internet page of the company system) returning me the...
  11. B

    Autocorrecting +1 to 1

    Hi, I cannot for the life of me figure out what I need to do to stop this from happening. I am working to edit some VBA that a colleague has created. There is a simple error in a line where the current text is .row 1 This needs to be +1, but everytime I type +1, it autocorrects it to the...
  12. B

    Stuck! Run-time error 50290: Method 'LinkSources' of object '_Workbook' failed

    Hey guys I have a macro that has always worked. Now suddenly it will not load in my XLStart folder when opening a document and when I try to go into the macro it states: Run-time error 50290: Method 'LinkSources' of object '_Workbook' failed Does anyone know how I go about fixing this?
  13. W

    run-time error 1004 - Why?

    Hi one & all, I have used this site many a time and it has helped me a lot, but this is my first post so if I have posted it incorrectly, I'm sorry. I am also aware that there is probably a smarter way to do this code, but as I'm self taught it usually a matter of trial and error for me and I'm...
  14. V

    Naming worksheet based on value in cell...ERROR message

    Hi, I am trying to rename my worksheets (540 of them) based on the value in cell A200 (which is a formula pulling together 3 cells, so =A1&" "&B1&" "&A3 ). I've checked all the sheets to make sure there is a value in cell A200. However, when I run the below macro, I get a Run-time error...
  15. P

    Run-time error '9' Subscript out of Range Help

    I am getting a "Run-time error '9': Subscript out of range" on the following code: Worksheets("Exhibit ""I""").Activate The worksheet name is Exhibit "I". If I remember correctly about what that run-time error means, on this line of code its saying it can't find a sheet with that name to...
  16. H

    Run-Time error '13' Type mismatch

    Hi everyone, can anyone please help me to correct this Run-Time '13' error? The error message popped up at the highlighted line of code. Here is the code With ActiveSheet.PivotTables("xLabor").CubeFields("[CSVFolderPivotTable].[FAIN]") .Orientation = xlRowField...
  17. 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...
  18. 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...
  19. 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...
  20. 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?

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top