error 1004

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...

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...

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...

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...

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...

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()...

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...

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...

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 =...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...