run-time error 1004

  1. D

    Please Help! Run-Time error 1004; Method range of object worksheet failed.

    Hello, I am in the process of transferring a lot of the sheet calculations and conditional formatting into vba for efficiency and in the process I am receiving an error that I cannot seem to figure out, "run-time error 1004; method range of object worksheet failed". I have attached all the...
  2. A

    Pivot Table Name is Not Valid Error - no missing data/columns

    Hi ya'll, first time poster here! I've been struggling for a few days on making this work. Context: I have a sheet called 'Imported Data' that contains thousands of rows of data & 15 columns. It will always contain the same 15 columns - the data comes from a | delimited text file. Through other...
  3. M

    Need help: Run-time error '1004' in VBA code

    I have been running this code successfully, for a while now. For some reason it just started throwing this error code: Run-time error '1004': Method 'Range' of object'_Global' failed Sub New_Associate() Dim NextRow As Range Set NextRow = Range("A1" & Sheets("Helper").UsedRange.Rows.Count...
  4. K

    Copying a column from another sheet to another - Error

    Is there something wrong with my code? Please help! "Sheets("Web Query").Columns(10).Copy Destination:=Sheets("Tracker").Range("A1")" - This is a working code but I want the copied data start at Range("A5") or Columns.(1, 5) "Sheets("Web Query").Columns(10).Copy...
  5. M

    Run-time error '1004': Unable to get the MInverse property of the WorksheetFunction class

    Dear all, I would like to solve a set of linear equations with VBA. I need to do this with VBA, because the number of equations is dynamic. While executing I get the error as metioned in the title and the last line is highlighted. I read a lot about the error, but I couldn't find my mistake...
  6. T

    Macro Used on Networked PC's

    I created a Macros for a spreasheet that works wonderfully up until it saves. It works just fine on my PC but when someone trys to run it on another Networked PC it bug's out at the place in red below: Dim dtDate As Date dtDate = Date Dim strFile As String strFile...
  7. C

    VBA SaveAs "Run-time error 1004 method 'saveas' of object '_workbook' failed"

    I want to save an excel file. -The file’s name and folders’s names will change each time a file is saved. -I recorded a macro to save the current file, then added variables defined by InputBoxes so a user could name and save each file to the correct folder.</SPAN> I get the error message...
  8. K

    VBA-excel page Save As PDF Run-Time Error 1004

    Hello, I am using below code to export Salary Payslip as PDF but i am getting below error while exporting. after export few Page, i am getting "Run-Time error 1004" (Document not Saved. The Document may be open, or error may have been encountered when saving). Code is below Option Explicit...
  9. Pyrgos

    Error 1004 setting up a range

    Hi all. I cannot understand what is wrong here. Dim Counter As Long Dim Counter2 As Long Dim AssociateList As Range 'Check Number of Lines with Reports Filled Counter = 1 Do Until ThisWorkbook.Sheets("Tracker").Cells(Counter, 2).Value = "" Counter = Counter + 1 Loop 'Check Number of...
  10. M

    office:mac 2011 "SaveCopyAs Error 1004

    I've been using the following Mac Excel Office 2008 macro SUCCESSFULLY (for years): Sub Auto_Open() With ActiveWorkbook .SaveCopyAs .FullName & ".Backup:" & Format(Now, "YYYY_MM_DD_HH_MM_SS") End With End Sub to save a backup copy in the files' parent directory in a filename.backup...
  11. Y

    Creating multiple PivotTables in a wb using multiple data sources (VBA/XL07/Vista)

    Howdy folks, I've been working on this problem for quite a while, and I can't get it to work properly. I am creating a macro for someone where data is consolidated from multiple worksheets into two summary sheets. From there, based on options selected on a "setup" worksheet, multiple...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top