1. E

    Error 1004 After I added a new sheet?

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

    VBA GetPivotData error handling

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

    Strange VBA problem with Cells.Formula: evaluation results in error

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

    Error 1004 SaveAs Method - Works 95% of the time.

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

    Application-defined or object error 1004

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

    Run-time error '1004' when copying from wksht A to B and have to move to correct tab on B.

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

    "Run-time error '1004': Unable to set the Values property of the Series class"

    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...
  8. Carl Colijn

    Error setting value of cells in disjoined named range

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

    Error: 1004: Application-defined or object-defined error

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

    VBA Cell color help

    Ok, this seems like it should be the easiest thing in the world, but there is obviously something critical that I'm missing. I've done a search of the forum but can't seem to find a similar issue. I'm writing a longer routine, but am running into an issue with filling the cell color. It...
  11. PoggiPJ

    Getting "Unable to set the bold property of the font class" error

    I am suddenly getting the same error on my own Excel 2003 code, which has been unchanged and working for the past 2 years now. I am also getting the "Not enough system resources to display completely" message just prior, but I am not certain that it is related. This particular user also...
  12. T

    Macro no longer works in Excel 2007

    I have a workbook / macro that no longer works since I moved to Excel 2007. When running some code that hides / unhides rows it gives me The offending line of code is Rows("35:40").Hidden = True Now, I thought this may be due to the worksheet being protected; however I do have the code...
  13. H

    Pasting Problems with simple macro

    heloo people - I need to copy seeral thousand records from a windows programme into excel. Unfortunately, the program does not allow me to select all of the records at once, only one row at a time. However, I can select the top row, copy the contents with Ctrl+c, move down a row with the down...
  14. T

    Excel VBA: copying range from one worksheet to another produces 1004 error

    Hello, The following statement in my little VBA program produces the "Run-time error '1004': Application-defined or object-defined error": Worksheets("calc_base(DO NOT DELETE)").Range(Cells(MW, 2), Cells(MW, 2).End(xlToRight)).Copy Destination:=Worksheets("Projekte").Cells(INPUT_ROW...
  15. N

    Run-time 1004 - "=" within a string

    Hi all, First post here. I'm getting '1004' on this instruction: Selection.Formula = ConcFormula ConcFormula is a String which has: =CONCATENATE("(select ";$B$6;" from ";$B$2;" where ";$B$3;" = ";"'";$B$4;"' AND ";$C$3;" = ";"'";$C$4;"'";")") The desired result is an SQL Select statement...
  16. J

    1004 problem with ActiveWorkbook.PivotCaches.Add

    I am trying to build a macro to be placed in a blank spreadsheet for use as a template. My development platform is Excel 2003 on Windows XP SP2. The script was initially recorded as a macro against a single data file with absolute range references and worked both on my develpment platform and on...
  17. C

    Recorded macro does not work?

    Hello, I came across a problem with my macro and decided to record a macro and see how excel did this, the result: Range("G14,I14").Select Range("I14").Activate ActiveSheet.Shapes.AddChart.Select however, when I run this macro i get the 1004 error on the last line?! The last...
  18. M

    Unprotect cell is STILL protected.

    I have the strangest problem. :confused: I have an excel form. A lot of different validations, VBA code and stuff. hverything works, however, i am stock on the easiest thing, that appears to be a bug in Excel. I am trying to protect a sheet. I specified which cells to be unprotected. However...
  19. M

    Range Problem - Worksheet Failed

    Here's what I'm doing... I have a combo box (called ClientListBox) that displays 2 columns, Column A (which is a unique id) & Column B (client's name) when they select the item, the click event should populate all the fields on the user form. Here's the code: Private Sub ClientComboBox_Change()...
  20. R

    Unable to get the Search property of the WorksheetFunction class.

    I am having trouble with IsError function consistently catching errors in my call to the Search worksheetfunction. For example, here is a snippet of my code that works just fine: If IsError(Application.WorksheetFunction.Search("__*-DEFERRED", netName)) Then If...

Some videos you may like

This Week's Hot Topics