1004

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

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

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

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

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

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

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

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

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

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

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

I added another sheet to my workbook and now my macro buttons are messed up, even though I am referring to the worksheet by sheet number. This is the problem function, it is supposed to pull a random percentage of the rows on the FromSheet, then copy them to a temporary hidden sheet, Sheet7...

I have code that pulls data from a pivot table and places it another table. It will work fine until it tries to do a look up in the pivot table for a value that isn't listed in the pivot table. The Pivot table is based on pulls from our ticketing system so it might not have tickets from all the...

Dear all, Can somebody tell me why .Cells(592 + gameno + 32 * opponent, 22 + Hometeam).Formula = "= " & .Cells(592 + gameno + 32 * opponent, 22 + Hometeam).Formula & " + " & .Cells(646 + daysconcerned, 18).Value results in an error? The error code is 1004: error defined by application or...

Hello, In general, the following lines of code work: ActiveWorkbook.SaveAs Filename:=mstrBARRA_FILE_PATH & astrAccountName(intAccountCount) & "\" & _ astrAccountName(intAccountCount) & ".por", _ FileFormat:=-4158...

Hi there VBA Pros, I am getting the following error when try the run this code (Application-defined or object error 1004) Sub Filter_PayRoll_Report_PivotTables() Dim MonthYear_Name As Range Set MonthYear_Name = Sheet3.Range("E2") With Application .EnableEvents = False .DisplayAlerts...

Great title. Concise but long. I have a VB script to move data from a particular tab on workbook A to the same named tab on workbook B. The macro button is on A's tab being copied. The problem is that the default tab of workbook B is not where the pasting is going. The users need the workbooks...

Hello, I wrote a couple of macros using Excel 2007, which work fine there - but returns "Run-time error '1004': Unable to set the Values property of the Series class" in Excel 2003. I'm making a graph with cost on the x-axis, and probability on the y-axis. I run a couple of scenarios, so for...

Hi all, I have named ranges that could contain disjoined cell references (e.g. a named range named "MyRange" set to "=Sheet1!A5;Sheet1!B2"). I want to set the value of all cells in these named ranges to certain values via VBA. But when I in turn try to access the actual range in such a...

Hi, This error pops up at the blue part I believe. Any idea why this is happening? Thanks! Wend Refresh_Click_Exit: Exit Sub Refresh_Click_Err: MsgBox "Refresh_Click Error: " & Err.Number & ": " & Err.Description Resume Refresh_Click_Exit