run-time error

  1. M

    Worksheet_Change private sub Run-time Error when deleting cell values

    The code below is acting as expected... If user enters "Personal" in any cell in Column J, cells on the same row in Columns K & L auto-fill with "Personal" If user enters either "Misc." or "Other Meals" in Column K, cells on the same row in column L auto-fill with the same word HOWEVER, any...
  2. L

    Custom List Sort with Run-time Error

    Hello - I hoping someone can help me with this. I created a macro using the Macro Recorder to sort a column on my spreadsheet by a custom list. CUSTOM LIST: PROJECT CANCELLED STAGE 1 - PI STAGE 2 - RD STAGE 3 - W STAGE 4 - LV STAGE 5 - LD PROJECT COMPLETE VBA CODE...
  3. D

    Is there a difference between Excel Office 365 and Excel 2013 ? -2147417848(80010108) Error

    Hi Everyone, I installed Excel 2013 on my PC. and made the excel workbook with VBA in it. It is now perfectly running. When I went for work and used my newly made excel workbook. it started having many problems in our office we use Excel Office 365. the Error I am having is...
  4. S

    Need help making powerpoint automation

    I have been working on this VBA code but I keep getting the error '-2147024809(80070057)' The specified value is out of range. Not sure why. I'm trying to copy values from the excel sheet to a powerpoint presentation for an awards ceremony. Any help would be appreciated. I'm using excel and...
  5. C

    VBA Run-time error '91': Object variable or With block variable not set Internet Explorer Controls

    Hello, I am having trouble with the below code. For some reason it will give a run-time error sometimes, but it is completely random. Unfortunately I can't provide the URL since it is internal but I'm thinking this error is due to a timing issue. As you can see below was my attempt at fixing...
  6. S

    Run-time error '1004' Application-defined or object-defined error

    I'm having some VBA problems. I've used the below code many times before on other workbook (just changing the specific parameters for each sheet)without any problem. However now I'm begging the "Run-time error '1004' Application-defined or object-defined error" error for the "East Mezz Input"...
  7. S

    Run-Time Error 13, error 2042

    I've been through this forum front and back and taking the suggestions from previous posts about this error has given me a lot of knowledge concerning this error, but the error persists nonetheless. Does someone see something I can be doing differently to stop this error from occurring? Sub...
  8. Z

    Run-Time error and crash after deleting a row in a table in vba

    MR. Excel Help Hi all, I am having trouble with a delete row macro for one of my tables in excel. When I run my "Call_Delete_Row" code in an existing table after I open my excel spreadsheet, the last row for two tables on two different sheets are deleted. However, AFTER I run...
  9. D

    Run-Time error '91'

    Hi guys, so i keep getting an error saying "Object variable or with block variable not set" the code used to work perfectly before i added something what i added was Set rng = Range(Range("A1"), Range("A1").SpecialCells(xlLastCell)) Set tbl = ActiveSheet.ListObjects.Add(xlSrcRange, rng...
  10. F

    Runtime Error: 2147024891

    I have code in a program that clears all data from all forms on all sheets. As part of this program I execute the following code to delete all existing charts: Dim wsItem As Worksheet Dim chtObj As ChartObject For Each wsItem In ThisWorkbook.Worksheets For Each chtObj In...
  11. D

    Run-time error 2485, running an Access macro from Excel

    Hi, I try to run an Access macro from an Excel macro. I've found some helping tips, but it still doesn't work. The relating part: Dim appAccess As Object Set appAccess = CreateObject("Access.Application") appAccess.opencurrentdatabase "G:\Risk Management\Common For Risk...
  12. K

    Excel VBA Run-Time Error 1004

    I wonder if anyone might be able to help me? I've come across an error in a workbook set up for the 2016 year (it was a direct copy of the 2015 original, clearing previous data and updating the date range). When I run the macro in the 2016 file, I am presented with the following error...
  13. D

    Challenge: VBA run-time error

    Hi fellow VBA practitioners, Today I have a challenging (maybe not?) exercise for those of you who know VBA. The case I'm about to describe is pretty simple, however completely kills all my weekend (second one to be precise). Case I managed to find & modify to suit my case the macro that would...
  14. E

    Run-time error - 2147417848 with mulit-page user form

    Hi, I'm new to creating user forms in excel so dealing with run-time errors is a little out of my wheel house. My user form has been working fine for over a year and then someone else edited my document and added a page to the multi-page user form. Since then this run-time error '2147417848...
  15. J

    Problems running VBA created in Excel 2010 in 2013 version

    Hi! I am trying to run the following in Excel 2013, but it won't work, I get run-time error "2147188160 Shapes.Paste: Invalid Request" and it is the blue line below which appearently is creating the problem. The macro worked perfectly in Excel 2010. However, now that I have had the file open in...
  16. D

    Run-Time 1004 Array formula help

    Hi, i keep getting the above error when trying to run this last bit of my code: Dim laddercount As Double Dim x, y As Double laddercount = Evaluate("COUNTA(R:R)-1") For y = 19 To laddercount + 19 For x = 7 To x + laddercount Cells(x, y).Select...
  17. K

    VBA - CSV data import: "Run-time error '62': Input past end of file"

    Hi all, I would like to use a macro script to import a (TAB separated) CSV file which was exported from a database. It seems to work - I can see that rows are being imported (although the first cell contains two additional weird characters: ÿþCampaign Name). However the script stops at "Line...
  18. H

    Vlookup for Userform, Run-Time error

    Hi! I made a userform via ActiveX Controls on my sheet, and I have a list box that uses Vlookup to fill in two other text boxes on my userform. Therefore, when the user clicks the part number from the listbox, the Part description ( TextBox1 ) and Std. Hours (TextBox2) for the part is filled...
  19. J

    Excel VBA -- Run-time error '-2147417848 (80010108)': Method 'Refresh' of object 'WorkbookConnection' failed

    I am getting this error on a workbook connections refresh that is done in VBA. I am using Excel Professional Plus 2010 and Windows 7. The code is part of a complex workbook that has 20 sheets, 330 procedures and 8,326 lines of code. The module with the error modifies a connection to an Access...
  20. M

    Convert to Late Binding for Excel VB to Outlook task list

    Here is the code I found and slightly altered. It gets a run-time error on the bolded line below. It worked prior to me trying to convert but now I need to make it compatible with other versions of Outlook. Please advise. Sub CreateTask() Dim OLApp As Object Dim olName As Object Dim olFolder...

Some videos you may like

This Week's Hot Topics

Top