run-time

  1. S

    Going totally bonkers - getting Run-time error '6' (Overflow)

    I am totally confused here. I was well into a project and assigned a value of 14464 * 5 to a variable and got the run-time error 6 - Overflow. Hmm, oh yes, I dimensioned my variable as an Integer. No problems. Changed to a Long. Saved, re-ran the code. Error 6 again, overflow. Sorry, but this is...
  2. D

    Run-time error "53": File not found - How to fix?

    Hello everybody, I am currently running an excel file in which I have created an order form that people can fill out with their information and the products that they would like to order. I am using a VBA code (please let me know in the comments if you want me to attach the entire code)...
  3. S

    Run-time error '1004

    Hello Experts: I have a rather irritating problem that does not make sense to me and I am hoping that someone can help please. I have some code that: Creates a list of files to be opened Opens each file in the list and scrapes some specific data from each file opened if present Places the...
  4. 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...
  5. 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...
  6. 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...
  7. 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'...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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?
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

This Week's Hot Topics

  • separating multiple Proper names (uppercase letters) from a list
    I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
  • 'for' Loop
    Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
  • Open specific pdf in folder with vba
    Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
  • What is wrong with this For Loop code?
    I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
  • Data to match
    Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
  • Shifting Columns
    Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

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