1004

  1. J

    VBA error 1004

    Hello I wrote a macro that moves through worksheets performing the same tasks in each. The macro works fine when there are a few sheets to go through, but when I start adding more worksheets, I get error 1004. I've started also getting a message box that comes up but its completely black so i...
  2. B

    Rows() error 1004 VBA

    Sub Macro15() ' ' Macro15 Macro ' ' Sheets("Plan4").Select ' the error start here Rows(3).Select Selection.EntireRow.Hidden = False Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove Selection.EntireRow.Hidden = True Range("A2:L2").Select...
  3. P

    What is the perfect solution for the run-time error '1004' No Cells were found?

    <!-- BEGIN TEMPLATE: ad_showthread_firstpost_start --><!-- END TEMPLATE: ad_showthread_firstpost_start -->Here I am getting it: For Each cell In Range(temp(0).Cells(1).Offset(0, 1), Cells.SpecialCells(xlCellTypeLastCell)).SpecialCells(xlCellTypeConstants, 1)
  4. S

    Web scraper. Run time error 1004 - Method 'Range' of object'_Global failed.

    Hi all, Struggling with a macro that I am using to scrape some data from a webpage. The code is as follows and is placed in a Module. Sub getdataEnglish() Application.Calculate Dim result As String Dim myURL As String Dim winHttpReq As Object Set winHttpReq =...
  5. D

    URENT!!! HELP!! Excel VBA. Been Stuck for 4 hours...

    Hi. This is probably very hard to follow, but I'll try my best because I am very desperate for help. Counts = number of columns I need to copy. BLANK = a variable that stores a certain integer such as 7,8,or 9. Height = How long I want the range to be. (This length is in row direction.) I am...
  6. M

    Vlookup Seems to Work, but Still Throws Error Code (1004)

    Good Morning, I have a vlookup that keeps throwing an error code, but only after it has completed it's job. It will populate all of the cells in the desired range with the correct values and then throw the error. Can anyone tell me what's going wrong with this? Dim v As Integer v = 2 Do...
  7. T

    Filter PivotTable

    I have a pivot table with 2 Row Label ([RAMI PN] & [U of M]), 1 Column Label [Date], and one Sum of Value [Weekly Inventory]. I had a slicer set up that would allow the user to filter by [RAMI PN], but 2 of the frequent users have Excel 2007, which doesn't allow slicers. As an alternative...
  8. M

    VBA Pivot Table Run-time Error '1004'

    Greetings, I am currently experiencing the following error: Run-time error '1004': Unable to get the PivotFields property of the PivotTable class on this line of code: With ActiveSheet.PivotTables("PivotTable2").PivotFields("Count of Project") I can change "Count of Project" to "Project" and...
  9. M

    VBA Pivot Table Run-time Error '1004'

    Greetings, I am currently experiencing the following error: Run-time error '1004': Unable to get the PivotFields property of the PivotTable class on this line of code: With ActiveSheet.PivotTables("PivotTable2").PivotFields("Count of Project") I can change "Count of Project" to "Project" and...
  10. J

    Error 1004 using sheet's Workbook_Open()

    This one is hopefully a simple answer from an expert. I used a previous program as a template for building a new one, but run into a 1004 error on launch. Don't spend mush time on this as I am sure I will figure it out quickly even without help. Upon launching, I get this error...
  11. S

    *Creating New Sheet with COM Addin*

    Hi, First post, so go easy and all that ! I am developing a COM addin that is essentially a port of an .xlam. The .xlam created two new sheets in the active workbook and all was fine and dandy. This is not the case with the COM addin. Below is the connection code (for testing purposes)...
  12. E

    Deleting Named Ranges error

    I have a macro that defines named ranges. Then I have a macro that clears the named ranges. This code has worked for me for a few years now in Excel 2007 and more recently 2010. I created a new workbook that has these macros in them and it worked fine. However, today, I started getting the...
  13. G

    Run-time error 1004 with ActiveCell.Formula command

    Hello everyone! I'm having an incredibly frustrating problem with VBA throwing an application-defined or object-defined error when trying to run the following code (I've cut out some irrelevant bits): Dim OriginalPrice As String OriginalPrice = ActiveCell.Value Sheets("Calculations").Select...
  14. B

    Object pasting causes 1004 error (only on a single machine) Please help.

    Hi Guys, This is my very first post on this fine forum and was hoping someone may be able to shed some light on this error. I've built a system for creating reports, its built in excel 2010 and works perfectly on 2010 and 2007 (on about 10 different machines). The problem is a single...
  15. W

    Runtime error 1004 when trying to use histogram from Excel add-in

    Hi, I am trying to make use of the histogram add-in in a macro but it errors out saying "Run-time error '1004':", here is the code. Application.Run "ATPVBAEN.XLAM!Histogram", ActiveSheet.Range("B2:B17") _ , ActiveSheet.Range("I1"), ActiveSheet.Range("E1:E24"), False, False _ , False, False I...
  16. J

    runtime error 1004 on sort macro? works on my pc but not on others.

    I recorded this macro to sort a multiple ranges on the same sheet. It runs fine on my machine, but when I email it to someone else they get a runtime error 1004. Any idea why or how I can fix it? Sub Sort_Owner() Range("C7:J26").Select Selection.Sort Key1:=Range("E7")...
  17. D

    Error 1004 using Worksheet_Change if multiple cells are changed using paste

    I'm using Excel 2007 I have a Spreadsheet with two sheets, one for data entry and one with a set of data for lookup I have written a Worksheet_Change macro that when an ID is entered into column 3 of the data entry sheet, it looks up certain columns in the data and if they are blank puts a cross...
  18. D

    vba copy problem, error 1004

    When I run this code Im getting a run time error '1004': The info connat be pasted becuase the copy area and paste area are not the same size and shape. Here is my code, does anyone know a way to get around this error so it will copy properly? Sub Table() Application.ScreenUpdating = False Dim...
  19. K

    range method run time error 1004

    Hi guys, i have small query regarding this and I havent found answer for this yet. Ofcourse I 'm new to this and not sure what do I do I have following code which works Range("F2 : F179").Select Selection.Sort Key1:=Range("F2:F179"), Order1:=xlAscending _ , Order2:=xlYes...
  20. D

    run-time error '1004' message when inserting image file

    Hi Folks, This is going to be a lo-o-ng post, so thanks in advance to those who power through it and reply to this thread. I have a mature (been in use for 3 years) spreadsheet that was created w/ Excel 2007 and saved as an *.xls file as most end users still run Excel 2003. This...

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