error 1004

  1. V

    Pivot table creation error 1004: Pivottable field name is not valid

    Hi all, I am having a peculiar error with excel VBA today. In the code below, are two ways I am using to create a Pivot table. Option 1 is creating the pivot table in the same sheet that the data is in. Option 2 is creating the pivot table in a new sheet. Option 2 does not work. As you can see...
  2. B

    Run-time Error '1004' Unable to Get Vlookup Property

    Hi all, I am trying to create a macro that will cross reference two lists and return the matches across the list. The problem is that the Vlookup function isn't properly working even though I know the variables in it are properly set (I copied and pasted them with VBA to make sure this wasn't...
  3. 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...
  4. T

    VBA Data Validation Error

    Hello All, This is my first post, so forgive me if my post is somewhat inept. I'm having trouble with some VBA code. I've got some cells that I need to create a drop down list based on the selection in another drop down list. I can do this with no trouble via excel, but trying to create it...
  5. L

    Help with debugging error '1004' for macros button command

    I'm a newbie to VBA codes. I know I'm going to run into a lot of errors in this macros button. I can run the macros with no problem without it assigned to check boxes or buttons, but once I paste the macros in the code for an active x button; I run into errors. Please help. My code is shown...
  6. J

    error 1004: method 'iteration' of object '_application' failed

    Hi, I've never used macros before, so attempting to debug this thing is like learning a new language. I got the following error when trying to open a document: 1004: method 'iteration' of object '_application' failed When I attempt to debug, I get this code: Private Sub Workbook_Open()...
  7. W

    vba error 1004 PasteSpecial method of Range class failed with pastespecial

    Hello I wrote a vba code to copy data from one sheet to another sheet. the code is like: Sub tt() Dim a As Long finalcolumn = Cells(1, Columns.Count).End(xlToLeft).Column For a = 1 To Columns.Count Sheets("sheet2").Select If Cells(1, a).Value <> 0 Then 'copy the first 3 columns of the first 5...
  8. D

    Runtime 1004 Error with code that seemed to be working... Help!

    Hi, I'm new to macros and don't understand why code that seemed to be working stopped after I'd saved the file and opened it up again an hour or so later without having made any changes to it... I'm trying to get a .pdf file of a specific print area run from a macro and for the file to be...
  9. S

    VBA Code: Merging worksheets from one workbook to another

    Greetings, I need to write a macro that merges all the sheets from the ISOHODataCopy1.xls workbook to the zmastertablestest1.xlsm workbook. They are the only two files in the Source_and_Master_Data folder. I have been using this code: Sub GetISOSheets() Path =...
  10. G

    Run time error 1004.. :(

    This is the macro what is the error.. When cell D40 is clicked all the macros are called and they are all the same (except ---- for different sheets).... When i debug it points to this an error - ""If Target.Address = "$D$40" Then Call Sheet9.Remove_Zeros"".... After i delete it it shows this as...
  11. J

    Error 1004 using variable range

    The following five lines of code are inside a loop in which i goes from 1 to 600. When i was 594 a condition allowed these lines to be executed. (The last was in my original code and the others were just added to try to figure out why the last had a problem.) The first three work and the last...
  12. J

    Error 1004 using variable range

    The following five lines of code are inside a loop in which i goes from 1 to 600. When i was 594 a condition allowed these lines to be executed. (The last was in my original code and the others were just added to try to figure out why the last had a problem.) The first three work and the last...
  13. M

    runtime error '1004': method 'range' of object '_global' failed

    Hi Hope you can help with this <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> problem! I included a code...
  14. T

    Unable to get the pivottables property of the worksheet blablabla

    Hi, I searched on all forum and I don't find the solution. I have error 1004, Unable to get the... on ligne: With PT.PivotFields("Product"). Then I tried a recorded macro... But it doesn't work too... I don't know why. Please answer if you have any suggestion. This is my code: Best, themeltdown...
  15. A

    excel file won't save when vba calls activeworkbook.refresh or save

    Hi, Can someone assit me by looking over my code below or alternativly at my workbook & make any suggestions as to why it won't execute when the file is shared? This is my first attempt at VBA & I'm stumped! It is part of a 'Scan in / Out' time capture workbook that I've written up. Reason is...
  16. B

    Data being Placed in Incorrect Cell

    Hi, my code is behaving in a way that I did not at all expect. What I was hoping it would do is go down column A and then apply a label and add a value depending on what is in the cell. If the cell is empty, then it will get a label and then in column B, a number would be added. If the name...
  17. V

    Getting a 400 error when I try to run a macro that worked yesterday

    I am trying to write a macro that automatically saves a copy of the spreadsheet and then attaches it to an email in preparation for sending it to the vendor. The thing is, the macro worked perfectly yesterday and now today, the macro returns error 400 when I try to run it from the spreadsheet...
  18. L

    help with macros button, running macros will work, but not in button function

    I need help with macros button, I run the macros, it will work fine. Once I copy and paste my macros to a button format it gives me an error. I got an error 1004, select method of range class failed. Can someone help me figure out what I have to do to make the button macros work? Here is my...
  19. B

    Manage Data (Application-defined error 1004)

    Hi I am a vba newb. What I tried to do is copying the data from one cell to another. Sub DataManipulate() Row = 13 ' Do Range(Cells(Row, 4), Selection.End(xlToRight)).Select Selection.Cut...
  20. K

    help solving a mystifying run-time error 1004?

    Hello all, I have a VBA code I've used successfully to update formulas on a spread sheet once a week. This past week someone pointed out to me that in end of the month weeks 2 formulas were updated incorrectly. Once I corrected the R1C1 formulas, however, I started getting a run-time error...

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
Back
Top