1004

  1. Y

    VBA Error 1004 when trying to put equals sign in cell value

    Im trying to do something like this "om" is the if formula but in my language Range("f3").Value = "=OM(+'1'!H3=0;"";+'1'!H3)" and for some reason i get the 1004 application or object defined error when i do this the first line of code works but the same error appers on the next line, why...
  2. R

    ActiveWorkbook.SendMail

    I have a macro that splits an Excel workbook into separate files and generates an email to the respective recipients for each file. I have a sub for each individual file created. I used to not have issues, but just recently received an error after the first sub successfully ran and sent an...
  3. S

    1004 the specified dimension is not valid for the current chart type

    Hi guys I've been stuck with this problem for a while now and was hoping one of you could help out :). The problem code is shown below and is being run from a word document which reads an excel file (myWB - opened with a GetObject call). With...
  4. G

    Error 1004 - Delete Method of Range Class Failed

    Good morning, I am attempting to sort a table of data, specify via the table filter function any numbers less than 2, select all rows of data meeting this criteria via special go to (visible cells only), paste these rows into a new sheet, and then delete the resulting empty rows. Unfortunately...
  5. S

    Code works or throws error sometimes

    Hello all, I've been trying to figure this out for a while now (I hope it is right in front of my face and I just can't see it). I have a line of code that works when it is ran in its sub, but throws an error when that sub is called upon. I get a "Run-time error '1004': Application-defined...
  6. W

    Error 1004 from a .CommandType = 5 line for data import

    Greetings wise ones I have been burdened with glorious purpose by my boss, to create an excell file that auto-imports a big ol' list of tables from our sharepoint database, every time the document is opened - mainly to use it as an auto-generating list which is then to be saved into a new file...
  7. I

    Run-time error '1004' when calling Application.Caller

    Dear all, this is my first post here and I have been using vba only for a month, so sorry for any naïve question. In my excel sheet I have a button which is connected to a macro which copies data from another workbook to the row of the button. The code is here below. I need to get the row...
  8. S

    Run Time Error 1004 on Do While Not ActiveCell.Offest(-1, RowCount).Value = ""

    I'm trying to write a macro to pull up a webpage with a tracking number, return the delivered date, then move to the next tracking code to do the same. I want that to continue down the spreadsheet until there are no more tracking numbers. This can't start at a particular cell every time because...
  9. R

    “AutoFilter method of Range class failed” (Run-time error 1004)

    The VBA below was created by recording a macro that applies AutoFilter to Column A, filters Column A for all rows containing the string “C U S T O M E R L I S T”, and then deletes all of those identified rows. This code executes successfully in Excel 2010 and 2013, but is generating the...
  10. V

    Error

    Hi guys, I get an application defined/Object defined error for the below, any help is much appreciated! Sub Macro1() ' ' Macro1 Macro ' ' For Y = 1 To 12 For Z = 1 To 50 For A = 1 To 50 For B = 1 To 50 X = Z + 3 C = A + 4 D = B + 5...
  11. N

    Run-Time Error '1004'; ?

    So I get this when I use my spreadsheet, Rint-Time error '1004'; Application-definded or object-defined error. Here is the code I have, Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count = 1 Then If Not Intersect(Target, Columns("A")) Is Nothing Then If Target.Row...
  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. S

    AutoFilter Method of Range Class Failed - Only With Array()

    Hello, I have tried Googling & searching this forum, but only seem to be finding unrelated issues that do not help me solve my problem. I have a macro set up with a final portion that filters through some columns and deletes and/or moves rows of information depending on filtered results. All...
  14. R

    Call a Macro from another WB - Run-time Error '1004'

    Hi everyone, I have written several macros to grab data from an external source and copy it to the open workbook but occasionally the exact same codes runs into the Run-time Error 1004. The setup is I have around 20 Workbooks each which have the below code within them referring to a single...
  15. S

    VBA Method 'Save As' of object'_Workbook@ failed

    Hello again forum, I posted earlier about a project I was undertaking and was wondering if anyone could help again please I am creating multiple workbooks, using a loop and pasting data into each of them in turn and saving them. Every now and again I get an error message pop up on screen "...
  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. A

    Pivot Table Runtime Error

    Hi all, this is a bit of a long one, so you're going to need to bare with me for a bit. I have some code which locks every sheet in a workbook simultaneously listed here: Sub LockAll() 'Disable additional features With Application .ScreenUpdating = False .Calculation = xlManual...
  18. A

    Runtime error 1004

    Hi guys, I've written a Macro that will copy what's in cells and then insert that X amount of times in the cells below(Being used to copy formulas). This works perfectly once I've unlocked the sheet, however, I receive the following error when trying to run this macro in a locked sheet: Runtime...
  19. L

    Runtime Error 1004

    Hi, I need some help here. Previously it was working fine with the exact same code. And lately, it has been showing runtime error 1004 with the highlighted as per below. I have no idea what is wrong when there was no change from the previous. Please help.... Sub SaveInvWithNewName()...
  20. J

    VBA If Value = Vlookup error

    Hi Guys, having a problem with some VBA. Its working until the Vlookup returns a "#N/a" then i get a: Run-time error '1004' unable to get the vlookup property of the worksheet funtion class. any ideas? i need it to check a selection of cells and highligh if they match a list in workbook...

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