run-time error 1004

  1. Chris_010101

    Error 1004

    Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next Sheet1.ShowAllData On Error GoTo 0 Dim fromRow% Dim archiveRow% Dim strMatch As String Dim wsTarget As Worksheet 'sheet to move data to Dim blnMove As Boolean 'whether to move data or not Dim...
  2. C

    Run-Time Error 1004 when Looping Application.OnTime Procedure

    I wrote a macro AutoPing() that allows to loop itself every 5 minutes. It works between before 23:50. But it gets error when it passes to next day (00:00). Please help me solve this error. Thank you.
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...

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