runtime error 1004

  1. B

    Runtime error '1004' no cells were found for Worksheet_Change

    I've attached my code below. The code works as I intended, but after running it displays the error "Runtime error '1004' no cells were found". Basically I want the code to change cell G3 to display today's date and return the value, if the formula in cell F3 changes. Anyone have any suggestions...
  2. X

    'Range' of object '_Global' failed ---runtime error 1004

    Hello below is my code, it works only 1/3 of the upper screen as expected, error msg comes out anywhere else. please help to identify the root cause. Thanks so much. Sub FindMax() ' Dim zoomCell As Range, zoomRng As Range, maxCell As Variant ActiveSheet.Cells.Interior.Color =...
  3. P

    Runtime error '1004' select method of worksheet class failed

    Hello, Getting above error when running the below Macro, and cannot figure out why for life of me. I have searched endlessly, but am new to VBA so hoping someone can assist. I understand the code I've used is problematic due to the use of .select and copying/paste back and forth b/n sheets...
  4. S

    Trouble With Find Works fine for days then Errors with "runtime error 1004 select method of range class failed"

    Here is all of the code. Makes me pull what's left of my hair out when it works for weeks then stops. Sometimes it will error on one Find, i.e. "UPN" then run fine on everything else. Then if I rem that error, manually create the range, sometimes if continues fine, other times it errors on every...
  5. S

    runtime error 1004 :PDF Export to Onedrive sub-folder

    Hi Experts, I have a problem so far, I tried to export my code to PDF format, the situation is runtime error 1004 what i did so far is that . with this path work just fine Filename:="https://d.docs.live.net/FBC3F27912XYZ123/Homeandcare work/Invoice Record History/" & "61_" & bil_id & "_" &...
  6. J

    SaveAs Runtime Error 1004 issue

    Hi Guys, I'm sometimes getting a runtime error on the "ActiveWorkbook.SaveAs" line Other times it works like a dream. I'm confused... Sub TestForDirAndSave() If MsgBox("Are you sure?", vbOKCancel, "Save?") = vbCancel Then Exit Sub Dim strDir As String strDir =...
  7. A

    Run-Time Error 1004: MS Excel is refreshing some data. Please try again later using Query

    I have a dynamic query in a sheet that has a parameter in cell C1. So, In column A there are codes, and in column b are those code descriptions and based on the value in cell C1, the query will refresh to display codes related to the value in C1. When the value in C1 changes I get a "Run-Time...
  8. C

    VBA Copy and Paste from Open File Dialog - Runtime Error 1004 Application-Defined or object-defined error

    I've got a macro to select a file from the Open File dialog, copy the data, and paste it into a worksheet in another workbook. However, I get a runtime error 1004 at the paste step. Anyone know how to fix it? Public Sub GetRange() Dim ReportWbk As Workbook 'workbook with report data Dim...
  9. V

    Error when using Workbooks.Open with the * character

    Hi I have been running a code which opens an excel file whose name changes each day. The naming convention of the file is essential "Input file-[date]-[time].xlsx". Given the time can vary, I have used the * character to specify the file name: filesource_path = "N:\Input files"...
  10. C

    VBA to upload Excel File to Sharepoint. Run Time error '1004'

    Hi all I hope you can help. I have a piece of code and what it does is if cell A2 is changed to anything other than "Enter Your Country Here" it finds and replaces all the "Enter Your Country Here" in the workbook with the new value in A2. This part works fine. The issue I am having is that once...
  11. D

    Cannot select/copy upper range in Excel

    I have a very large spreadsheet (850 columns and 5000 rows) that I am trying parse into smaller chunks and then send into Access. I have a loop that cycles through the columns and sends 120 columns at a time to a separate workbook (via a strRange) variable. Then, the new workbook is imported...
  12. L

    Certain URLs for Inserting Pictures into Excel Sheet Returns a Run Time Error :/

    I have a spreadsheet that has some macro that takes picture url's from one column to display in another. When I run the macro (Not sure if I said that correctly. I am new at this stuff), it goes smoothly until I reach url's that look like these ones...
  13. J

    I am getting Runtime error 1004" error message when you try to copy and to paste in Excel 2010

    Hi I am getting Runtime error 1004" error message when you try to copy and to paste in Excel 2010, when the macro tries to paste sheet 5 into sheet 6, here is the debug point where the code is failing the text is in orange. Can you help? I am trying to figure out why it is breaking at this...
  14. M

    runtime error 1004 paste method of worksheet class failed

    Hi All! I keep receiving an error when copying data over: "runtime error 1004 paste method worksheet class failed" at ActiveSheet.Range Sheets("Macro").Select Cells.Select Range("A1").Select ActiveSheet.Range Columns("D:D").Select Selection.Insert Shift:=xlToRight...
  15. D

    VBA Runtime Error with XLSB file

    I have a large macro enabled file I saved as a XLSB to reduce size and opening time. Now however, if it is not the first excel file open, I get a Runtime Error '1004' when my macro events run. However, when it is the first file open, the macro events perform perfectly. Hopefully someone has...
  16. N

    Runtime Error 1004

    I'm a novice at VBA and am using the immediate window. I am getting a Run-Time error '1004': Application-defined or object-defined error and I don't know why. I have the following code in my immediate window. I have a similar code, but for the Income Statement which works just fine. I...
  17. J

    Run XLAM from macro

    Hello, I'm trying to run an XLAM file from a macro. Using the run method I get the following error Run-time error '1004': Cannot run the macro (filepath) The macro may not be available in this macro or all macros may be disabled. I'm quite familiar with VBA, but am just starting with .xlam...
  18. D

    VBA Runtime Error 1004 Unable to Get Match property of the WorksheetFunction class

    Hello, I am looking to populate a calendar grid with select piece of information. My Calendar Grid sheet is named "Calendar". The sheet with the data is named "Input". The macro successfully completes one cycle but I get an error in the 2nd cycle once I arrive at the Cindex line of code...
  19. L

    VB Text to column

    I'm not sure what I'm doing wrong. I've tried multiple things and looked at different threads, but i still get the Run-time Error '1004'. I'm just trying to do text to column for range A:A in Sheet "LY". This is the code I've been using Sheets("LY").Select Selection.TextToColumns...
  20. N

    Trying to Replace a Combo Box with a List Box (Form Control) in Excel Worksheet

    Hello, I'm working with an excel worksheet with macros and there are several Combo Boxes (Form Control) on one worksheet. Most of these Combo Boxes have only 2 items to choose from so I thought it would be nicer to have List Boxes to replace them. I started by trying to replace just one combo...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top