run time error 1004

  1. Z

    StDev Macro

    Hi, I have below macro that calculate StDev and it was working perfectly fine but I got error "unable to get the StDev property of the worksheetfunction class" whenever the I have empty cells. How can I fix this and make it ignore the empty cells and move on with other cells that have data...
  2. L

    Newbie VBA coder struggling with a Run-time error '1004'

    I have a fairly simple macro built that is supposed to delete row 2, bold format font in row 1, auto fit column widths, and sort by column. The number of rows in the worksheet will vary, but the number of columns are the same every time. I've done a lot of searching in forums for the 1004 error...
  3. S

    VBA Publishing temporary HTML file, run time error 1004

    Hi all Updating someone else's VBA (no longer at company so cannot ask them!) and I keep getting this error, it is one of the very last stages of a long macro that autopopulates a number of emails. I gather the error is likely due to an undefined path/file name but I have not worked much with...
  4. S

    VBA Publishing temporary HTML file, run time error 1004

    Hi all Updating someone else's VBA (no longer at company so cannot ask them!) and I keep getting this error, it is one of the very last stages of a long macro that autopopulates a number of emails. I gather the error is likely due to an undefined path/file name but I have not worked much with...
  5. S

    Run-time error 1004 Copy and Paste

    I have tried a number of different variations to copy and paste but they are not working. I keep experiencing a run time error. Sub Filter() Dim Wkb As Excel.Workbook Dim ws As Sheets Dim i As Long Dim LastRow As Long Dim LastRow1 As Long Dim Rng As Range Dim deleteRange As Range Set...
  6. B

    Run-time error '1004': while trying to p_rint out

    Run-time error '1004': while trying to print I have created a user form were I select certain checkboxes for the sheets I want to print and then run the code below to print. If possible could someone take a look and see what I need to correct to fix this problem? Thanks for the help as always...
  7. G

    Run-time error '1004' While trying to generate PDF

    Hello all, I am encountering the following error message when I try to generate a PDF from a checkbox list of multiple sheets. "Run-time error '1004': Document not saved. The document may be open, or an error may have been encountered when saving." Any help would be appreciated with helping...
  8. E

    Not saving from User form to Workheet

    Whenever I push "Save Donation" I an getting a Run-Time error '1004': Application-defined or object-defined error. I have looked over the code as well as go one by one through the text boxes to see if there was a mismatch in spelling or location. It references the sheet I am asking it to prior...
  9. K

    Run Time Error '1004': Select Method of Worksheet class failed

    Hi, I'm having trouble with this error that appears whenever I try to run macros. Sub Filter() Sheets("Combination").Select Range("A4:AJ598").AutoFilter ActiveSheet.Range("$A$4:$AJ$598").AutoFilter Field:=1, Criteria1:="Y" ActiveSheet.AutoFilter.Range.Copy...
  10. I

    Run-Time error 1004 when clearing cells

    I'm scanning ID & Username into "column A1" the vba then moves the cursor to the right to "column b" finally down to "A2,B2,etc.... But if I make an error of some sort and click on the cell to delete the ID or Username this Run-time error '1004': Application-defined or object-defined error...
  11. J

    Run-time error 1004: method range of object worksheet failed

    Hello everyone, I am attempting to use the macro below, but for some reason the last section of the code (specific line item bolded and underlined) results in an error. "Run-time error 1004: method range of object worksheet failed" Any thoughts on why this is happening and how I can fix this...
  12. R

    run-time error '1004': Paste method ow Worksheet class failed

    One user (of many) receives the run-time error '1004': Paste method of Worksheet class failed on the line "ActiveSheet.Paste" (see below for example macro) I have many users here at work that use a whole slew of these types of macros as tickmarks in their Excel workpapers. They work for...
  13. E

    Run Time Error 1004 Can't read path

    Why it can't read my path code? I want it to copy all my workbooks in that folder. Path1 = "C:\Users\user\Desktop\DailyRecord" Filename = Dir(Path1 & "&.csv") Do While Filename <> " " Workbooks.Open Filename:=Path1 & Filename, ReadOnly:=True
  14. C

    Run Time Error 1004 AutoFilter method of Range class Failed

    Hi All I hope you can help. I am getting the error Run Time Error 1004 AutoFilter method of Range class Failed When I run my code, the funny thing is It works perfectly by itself, but when I put it into the other code and call it, it gives the error Run Time Error 1004 AutoFilter method of...
  15. B

    Run Time Error 1004

    Hi Guys, I am using the below to save sheets as workbooks but it gives me a run time error 1004 saying this file cant be saved using the extension I have requested but my understanding is that .xlsm is the correct extension Sub Export_Sheet_To_Order_File() Dim wb As Workbook Dim myPath As...
  16. J

    Copy Hidden Template - Results in Error

    Hi - I have a code (shown below) that is creating multiple copies of a template worksheet and number sequentially. The problem is that I would like to have the template worksheets hidden, but when I do this I get a Run Time Error 1004: Method Select of Object_Worksheet failed. If not hidden, it...
  17. B

    Run Time 1004 Error Unable to get the CountBlank property of the WorksheetFunction class

    All, I am trying to create a macro that will work with a button to display either answers to a problem if the test has been completed or "Please finish the test before answers will be displayed". Here is my current code Sub Button_1() Dim Answers As Range Set Answers =...
  18. M

    VBA code error when using File Exit

    Hi In Excel 2010, under a Workbook_BeforeClose event, I have code to deselect any multiple selection of sheets. Private Sub Workbook_BeforeClose(Cancel As Boolean) ActiveSheet.Select 'removes multiple selection of sheets End Sub This works fine, when closing an individual spreadsheet...
  19. D

    Run time error 1004

    Hello everyone i have encountered a problem with this run time error 1004 application defined error or object defined error can any one help me out of this. i have highlighted the line where the error occurred with a sad smiley please help me out Private Sub CommandButton1_Click() Dim lrow As...
  20. J

    Merge Cells VBA Run Time Error 1004

    Hello, I'm having a small problem with part of a code - and just dont know why it isn't working when using Private Sub Workbook_Open() whereas it works when using commandbutton()! Private Sub Execute() 'Clear All Previous Data With Sheets("Summary").Range("A3:K310") .Interior.ColorIndex =...

Some videos you may like

This Week's Hot Topics

Top