run-time error '1004'

  1. Small Paul

    Paste Special - Run-Time Error 1004

    Hi I am having difficulty with a Paste Special line in my VBA and cannot work out why. I have searched various websites and tried a load of different things, without success! The section of code is: Worksheets("Required Data").Activate ActiveCell.Offset(0, 2).Copy detail = ActiveCell.value...
  2. D

    Run-time error '1004': Method 'Activate' of object '_Workbook' failed only on new PC

    Hi Folks, I have an old excel model last modified in 2010 that was written by a pretty decent VBA / SQL programmer who has since deceased. All our old machines are running Windows 7 professional on a 64 bit OS using 32 bit Excel 2013 (8 gb RAM). A new PC installed recently runs...
  3. D

    Loop not working - Run-time Error '1004': Select method of range class failed.

    Hello All. I have an issue in my loop and I have no idea why it's not working. Can anyone please help me. It's the only thing (so far) holding me back from completing this project. In my Payroll project there is a time, every 2 to 3 years, our Government National Insurance Service (a.k.a. NIS)...
  4. H

    Macro's not working on Mac - Run-time error '1004'

    I built macros to automate a sales reporting process. I am leaving the company and trying to ensure the sales report will be usable after I leave. My boss who will be running the report uses a MacBook Air. When I run the macro, the first error that comes up says "Print - Error while printing"...
  5. mdfahiem

    Run-time error '1004' for a scroll bar (form control)

    Hi Gurus, I have a scroll bar (form control). There are cells which are updated based on the scroll bar value. I want to protect the work sheet and I have selected the cells to be protected and have them Locked in format cells --> Protection. When I scroll to next level, below message is...
  6. C

    Run-time error '1004' Application-defined or object defined error

    Hi. I am having an issue with a macro I wrote that reformats a report I receive in Excel. One of the commands looks for the blank cells in column A and based on the content of column C, enters the appropriate value. Frequently, when I run the macro I get "Run-time error '1004'...
  7. DPChristman

    Macro Issue

    I am trying to rung a 'save as file name' macro, and getting the error: Run-time error '1004': Microsoft Excel cannot access the file c:\program files (x86)\microsoft office\office 14\91cd6000. there are several possible reasons: -The file name or path does not exist. -The file is being used by...
  8. M

    Run-time error '1004': Select method of Worksheet class failed. Help :)

    I'm trying to loop through my sheets and when I get to the 8th sheet, it has this error: "Run-time error '1004': Select method of Worksheet class failed." Anyone see my mistake? It works great through the first 7 sheets, not sure why it wont continue. My Code is: Sub...
  9. K

    Run-time error '1004': Microsoft Excel cannot paste the data.

    Hi, I have a macro to open files -> copy data from a1:b800 -> put it to general file and doing solver function. But when I'm start a macro I'm get back information "Run-time error '1004': Microsoft Excel cannot paste the data." Frequency of this message is 80% of time when I'm start a macro. I...
  10. T

    Run-time Error 1004 - But everything is the same!

    Hello everyone! Long time reader first time poster here... I have a macro that pulls data from a table into a pivot table and then sorts it. I use the same process/code 4 times so that I can break up the data into 4 separate pivot tables. The code I use for the first 2 pivot tables works fine...
  11. 2

    VBA Hell

    Here is my code Sub SaveWOWithNewName() Dim strNew As String Dim F5 As Range strNew = "C:\Users\AdminAssist\Dropbox\Work Orders\Work Order Index\@1.xlsm" Application.ScreenUpdating = False With ActiveSheet Set F5 = .Range("F5")...
  12. N

    Run-Time error '1004':

    Have some code that should determine users My Documents path, Create a New Folder in their documents, then save a newly created PDF document in that folder. It runs fine on my system. When other users try to run it, they are getting: Run-time error '1004': Document not saved. The document...
  13. I

    If Statement Formula not working when recorded in a Macro

    Hello, I am new to posting in this forum and fairly new to Macros/VBA so please excuse me if I miss anything. I created the following long formula that gets me the info I need to create an accounts receivable aging report: =IF(X2="CM", "Credit", IF( X2="PMT", "Unapplied", IF(X2="INV"...
  14. H

    RTE 1004 when filtering pagefield via macro

    Hello, I am currently trying to make a simple button that filters a PageField in a Pivot table. Worksheets("SN VIEW (2)").PivotTables("SN").PivotFields("DELIVERY SEQUENCE").PivotFilters.Add Type:=xlCaptionContains, Value1:="*ONSITE*" This will give me a Run-time error '1004'...
  15. J

    Mac recorded Macro does not work with windows. Run-time error 1004

    Hello all, I have been given a macro recorded on a mac and it works fine with Mac Excel 2011. Unfortunately, I need to make it to work on a windows machine, but it comes up with an error message "macro unable to set width property of the window class. Run-time error 1004". When I press debug...
  16. H

    Excel macro issue - Run-time error '1004' Method 'SaveAs' of object '_Workbook' failed when trying to save file via macro

    Hello, I am posting this question to the forum after reviewing several other posts trying to find a solution with no success. OS - Windows XP Office version - Office 2010 What the issue is - I have developed an Excel 2010 template with macro's (.xltm) that has some sales data pasted into it...
  17. K

    VBA, glitch or coding error?!

    Hello All, The code below yields run-time error 1004 on the lines for AH15 and AH44, but works fine for AH19 and AH48. The only change to the formulas in AH15 and AH44 was "-R[-5]C[-20]-R[-5]C[-19]-R[-5]C[-11]" replaced "-R[-5]C[-21]-R[-5]C[-12]". The macro uses an input box for the week number...
  18. L

    Running macro from another workbook

    Hey all, I think i'm missing something super simple here but yet can't spot it. I have a simple macro that opens another file and runs a macro within that file. It worked the very first time and then stopped running. It gives a Run-Time 1004 error on Application.Run line "Cannot run the macro...
  19. J

    Error-Handling for Repeat VBA Code for Multiple Values

    I think the code is fairly self-explanatory, but I'm trying to search for a number (VehNum) in a column (VehCol) and copy all of the rows with the same number in the that column to a new sheet. I'm receiving a "Run-time error 1004: Application-defined or object-defined error" in 14th line of...
  20. M

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

    I am getting the subject mentioned error while processing the following code: Public Function CheckIRR1(Company As String, Term As Integer, Premium As Integer, ProposalDate As Date, YearlyInstalment As Integer, DateOfLastPayment As Date, DateOfMaturity As Date) Dim nArraySize As Integer...

Some videos you may like

This Week's Hot Topics

Top