error 1004

  1. H

    Error 1004 in Excel VBA when creating e-mail

    Please help with this new error that all of a sudden occurs in a spreadsheet that I have been using for 5 years now. The spreadsheet works well on 3 other PCs. All of the PCs are running on the latest update of win10 x64. The relevant part of the VBA code reads: Sub Klaar() ‘ ‘ Klaar Macro...
  2. K

    Error 1004 - Add Hyperlinks to a range with Cell Value in string on Open - Doesn't work when opening in Shared Mode

    Hi, I have the following piece of code running when opening a workbook. I want this workbook to be shared, but when I open in shared mode this piece of code gives me a run-time error '1004': Application-defined or object-defined error. Works fine when not in shared mode. I have googled...
  3. S

    VBA Error 1004 - CopyPicture method of Range class failed

    Hi all. I am trying to run the following code one after another for three different ranges. The macro extracts the ranges and save them as pictures. Sub ExportBRRangeToPNG() '--exports selected range to png file ' jpg is not appropriate format for this output ' default filename is...
  4. T

    Worksheetfunction.Match Error 1004 on one code, but not the other nearly identical one

    I have 2 VBA codes that are almost identical to each other, the only difference is that one of them has a prompt for message box with input to fill in column B. Basically code 2 is identical to code 1, but with all the columns shifted one down (B-C, C-D, etc). Below is code 1 Private Sub...
  5. R

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

    Can't quite see/figure out what I've done wrong (I don't know what I don't know :confused: ). I'm getting: Run-time error '1004' Method 'Range' of object '_Global' failed I've tracked the error down (I think) to the FOR-NEXT loops in the following snippet of code (edited for...
  6. C

    Runtime error 1004 with ExecuteExcel4Macro

    I have recorded a macro and now it is giving me a runtime error 1004 "There's a problem with this formula" in connection with ExecuteExcel4Macro. I have tried with double quotes without success ExecuteExcel4Macro "(2,1,"""";;;@"""")" Can anyone point to an error in the code? Sub...
  7. M

    run-time error 1004 : Application-defined or object-defined error

    Hi Excel folks, I m trying to move every second row at the end of previous row. This below code is being applied from the third row. I m getting the desired out , but i m also getting the below error. " run-time error 1004 : Application-defined or object-defined error". I m aware that...
  8. zakasnak

    VBA error 1004 Formula is missing a range or a defined name

    Good Morning! I have vba that purges data for public posting, then saves each tab (named range) as a separate pdf to combine & post to the web. I'm getting a Run-time error '1004' "This formula is missing a range or a defined name" on Named Range(Table_7), on Tab "Table 7", when trying to save...
  9. S

    Issues Deleting all Named Ranges -- Quite confused

    I have 50 named ranges. Some of them are just a range, others have dynamic ranges (formulas). None appear to be incorrect. Everything is calculating correctly based off of the named ranges. I have used the Name Manager to filter for Names with Errors and there are none listed. I need to...
  10. C

    Run Time error 1004 while converting XML file

    HI All. I am getting belowerror while converting XML file to excel. 1) Con-Ledger-2015-03-31.xml 2) Std-Ledger-2015-03-31.xml I have 2 files in a folder I am able to convert the firstfile were as 2nd file shows the below error. The xml file cannot be opened because of error...
  11. O

    VBA: creating name for ListObject column range fails when it's in "A1"

    Hi, I want to create a name for the data range of a given table column, using the syntax "Table[Column_name]", so that if the table moves, expands, shrinks, is renamed, or reorder columns (...), the range referred to by the name is still correct (per opposition to use the range address syntax...
  12. R

    VBA 1004 error

    Hello. I am sure this problem has come up before, but as a tyro I just don't know where my code is going wrong. I an trying to set up a macro, which will copy some data from a summary sheet into another sheet in the same workbook. Here is the code which is giving me angst: ' Add the new sheet...
  13. W

    PasteSpecial Error

    I'm copying (Ctl-C) tabular data from a website and wanting to Paste it into my spreadsheet. When I manually select the destination cell and type Ctl-V it works just fine. However, when I try Pasting it via VBA I'm getting the Run-time error 1004 (PasteSpecial method of Range class failed). My...
  14. B

    Runtime Error '1004'

    I keep getting the following error and I don't know why: Runtime Error '1004': Method range of object global Failed Here is my code with the line causing the issue denoted with the *. Sub Button1_Click()ActiveSheet.Range("AL2:AL399").Value = 0 ActiveSheet.Range("BH2:BP399").Value = ""...
  15. A

    Problem with on error goto, in pivot table macro - I still get an error

    hi I am trying to create an automated script to automatically change multiple examples of the same field dropped into a pivot table into defined calculations of that field. eg change the first instance into average, second into stdev, 3rd into count etc. This requires them to be renamed to...
  16. W

    Run time error 1004 - cannot sync slicer caches with different size

    Hi, I get run time error 1004 when I run the following code, which should synchronize the slicer caches: Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)Dim sc1 As SlicerCache Dim sc2 As SlicerCache Dim si1 As SlicerItem Set sc1 = ThisWorkbook.SlicerCaches("Slicer_SolName")...
  17. C

    run-time error 1004 Unable to get the PivotFields property of the PivotTable Class

    I'm running into a strange problem, for many years I have used these excel macros and all of a sudden I started to receive errors that only appear on one computer. This macro and pivot issue doesn't exist on any other computer I have tried. So excel was uninstalled and a fresh clean updated...
  18. C

    File Dialog Excel 2013 Error

    Hi, I have the below code that is working for most of my users but is crashing in the red line for some of the users. The only common trend I've found for those that this is not working is that they are Excel 2013 users as everyone else is Excel 2010. The Excel 2013 users have a run-time error...
  19. G

    vba - copy filtered data to table

    Hi guys, I try to filter data that I have in Macro file in DataSheet ('DS'). I need to take filtered data only (w/o header row) & copy it into different workbook/sheet 'SFDCReport', where there is a Table (Header row on line 12, 1 data row on 13). With this code, I received some Error 1004 -...
  20. andrewb90

    can't hide cells using vba when sheet is protected

    Hello all, I have a worksheet change event that hides/unhides rows, but when my sheet is protected it doesn't work. now, the sheet is protected in vba uing this: ActiveSheet.Protect "password", _ DrawingObjects:=True, Contents:=True, Scenarios:=True _ ...

Some videos you may like

This Week's Hot Topics

Top