runtime error 1004

  1. C

    Update Pivot Table and Enable Outlining on Open returns Runtime Error

    Good Day, I am very new to vba and am trying to make this work. I have a workbook with more than 20 sheets. Each one of them has a pivot table with a source in an external workbook and each one of them has an outline that allows group/ungroup a set of rows. I need all the pivot tables to be...
  2. P

    Run-time error 1004

    Hello, I've created a calendar with macros, however when I try to protect the sheet I get a runtime error. I'm learning macros and have tried various codes but have not helped. Here is the macro I have: Sub HideMonths() Application.ScreenUpdating = False Dim rngDates As Range, rngMonths As...
  3. I

    runtime error '1004 'Range of object _Global failed

    Hi all of a sudden i am getting this error "runtime error '1004 'Range of object _Global failed". earlier this used be working fine, dont know what happend as i am new to VBA. when i debug this i am getting this error at the following code Range(rcout & outcolml & 1) = Range("'heads'!" &...
  4. T

    Exporting worksheet to CSV Runtime Error

    Hi all, As a newbie to macros I am having trouble trying to save a worksheet to CSV file. The macro worked to .txt but when I change it to .xlCSV it comes up with runtime 1004 error, method 'save as' of object '_workbook' failed. Any help would be amazing. Cheers Sub Export7400_setup_Click()...
  5. T

    Runtime Error: 1004 - Execute Macro when a condition is met in two columns

    First off, sorry to ask about runtime error 1004, but I am not that familiar with VBA and I cannot find a solution anywhere that I can make sense of. The problem I get is: Run-Time error '1004' : Application-defined or object-defined error Here is my code: Sub DateInsertion() ' '...
  6. T

    Runtime error '1004' Method 'Location' of object '_Chart' failed

    Hello all, I am currently working on a code, which is used to visualize graphs. I copy paste the data from other work books and create the graph. It works fine in the debugging mode, however I come across run time error when I run the macro. Call createchart1(j, k, j + i1 - 1)...
  7. S

    Elseif statements - 'Application-Defined or Object-defined error' help

    Hello, Currently I am trying to use Elseif statments to copy and paste information into a target cell from another cell on the same worksheet based on the value of the target cell. When I try to run my code, I recieve the following error message: 'Run-time error 1004: Application-based or...
  8. H

    Sort Method: Run time error

    Hello! I've spent a while now looking online for a solution to my problem, but I'm still getting the same error. I have a range in a worksheet (LAYOUT) that I want sorted first by column B ascending then by column C ascending. I do NOT want to select or activate the worksheet, if that is...
  9. M

    runtime error '1004': method 'range' of object '_global' failed

    Hi Hope you can help with this <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> problem! I included a code...
  10. netspeedz

    Runtime Error 1004

    Had some problems with a computer so I had to completely reinstall Windows XP and subsequently Microsoft Office 2003. I have an Excel document that had no changes between the time I reinstalled Windows XP and Excel and opened up the Excel document to test the new Office install. In this Excel...
  11. J

    Run Time Error 1004

    The following code worked several times and is now giving a Runtime Error and tagging the dst.value = frm value portion Sub UpdateWeekly() Application.ScreenUpdating = False Dim i, ofst As Integer Dim frm, dst As Range Set frm = Sheets("Weekly").Range("K5:BDI6") Set dst = frm.Offset(2, 0)...
  12. H

    Excel VBA application defined Error 1004

    Hi All, Hoping someone can point me in the right direction with some code i am writing. Background: I currently have 8 workbooks saved in a given location. Each workbook is in the same format and has a worksheet called "Stock" I have written code that loops through the file and opens each...
  13. C

    Trouble with FormulaArray limitations and Method 'Range' of object '_Global' Failed

    Hello, Im trying to make something that will manipulate data consistently across multiple workbooks. I am having trouble with the 255 character limit of the FormulaArray function (I tried the .replace workaround and I'm not sure if I did it correctly) and when I'm not getting that error I'm...
  14. M

    Getting a MS Visual Basic Run-time error '1004' Application-defined or Object-defined error on exit of Excel

    I know nothing about Visual Basic,so bear with me. I keep getting this error when I try to close Excel & I have no idea why or how to isolate the issue. This happens on any workbook. I want to say that I have tried to repair Excel, but that didn't fix the issue. Please help!!!!
  15. P

    Help with copying data to another worksheet

    Hi all, I have a macro which I want to search through a list of dates in a range, and for each date found where the given criteria is met, paste the column header into another sheet in the same workbook. Here is my code... <code> Sub compile() Application.ScreenUpdating = False...
  16. P

    Run time error 1004

    Hi people, I'm pretty new to vba and keep getting a run time error 1004 on the highlighted line when i run the following macro... <code> Sub auto_open() Dim cwb As Workbook Dim arow As Long Dim brow As Long Application.ScreenUpdating = False Set cwb = ThisWorkbook Sheets("Domestic...
  17. L

    Issues with Application.Goto

    Running Excel 2010 Here is my code: 'Select the correct Range to copy and copy into the sheet Set FromRange = Workbooks(Info.FromBook).Worksheets(TEMPLATESHEET).Range(NumHeads) Set ToRange = Workbooks(Info.ToBook).Worksheets(Info.ToSheet).Range("A" & RowTo) 'Copy the template...
  18. O

    RunTime Error 1004 Invalid Object Name when connection to SQL Server Database

    Hi, I've searched the forum and not found any posts reporting this problem. When running a QueryTable command in VBA I keep getting the error: RunTime Error 1004: Invalid object name: 'MyDatabase.Data.Amount_Source' What I cannot understand is that when I copy the SQL Query Command Text...
  19. W

    Excel 2007 Selection.Characters.Text 1004 Error

    All, I have a macro that does some error checking on the user's input, changes the control/shape text and assigned macro, and then save the file to a SharePoint site. The problem arrises when the macro changes the control/shape text; for some people it works without issue (like myself) and for...
  20. R

    Runtime error '1004': Unable to get the countif property of the worksheetFunction class.. Please Help!

    Hi all, This is my first post, so bear with me. I am currently populating a whole lot of different/identical data to a worksheet and then using a concatenated string in front of all the different figures I am determining which ones are the same. However I now need to delete the duplicate...

Some videos you may like

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top