VBA – Run Time Error 1004 ‘Application Defined or Object Defined Error’

by

Your cells object is not fully qualified. You need to add a DOT before the cells object. For example

With Worksheets("Cable Cards")
    .Range(.Cells(RangeStartRow, RangeStartColumn), _
           .Cells(RangeEndRow, RangeEndColumn)).PasteSpecial xlValues

Similarly, fully qualify all your Cells object.

More Related Contents:

  1. Getting error Procedure too large in VBA Macros (Excel)
  2. Workbooks.Open Method in VBA
  3. Consolidating worksheets into one
  4. How do I get values from a hidden worksheet using VBA [closed]
  5. How to copy cells that contain certain text to another worksheet [closed]
  6. VBA Macro for copying and pasting columns on same excel sheet
  7. Excel VBA, code to count the # of filled cells, then find highest and 2nd highest and subtract the corresponding column #’s [closed]
  8. Levenshtein Distance in VBA [closed]
  9. VBA Runtime Error 1004 “Application-defined or Object-defined error” when Selecting Range
  10. How do I base64 encode a string efficiently using Excel VBA?
  11. Assign event handlers to controls on user form created dynamically in VBA
  12. Programmatic Access To Visual Basic Project Is Not Trusted
  13. Can I make this macro more efficient or faster?
  14. Conditional Formatting using Excel VBA code
  15. Controlling IE11 “Do you want to Open/Save” dialogue window buttons in VBA
  16. How to get the background color from a Conditional Formatting in Excel using VBA
  17. VBA Excel Populate ListBox with multiple columns
  18. VBA Integer Overflow at 70,000
  19. How to count up text of a different font colour in excel
  20. VBA Macro to compare all cells of two Excel files
  21. What does ReDim Preserve do?
  22. How to create a separate CSV file from VBA?
  23. VBA: How to change the value of another cell via a function?
  24. Convert RTF (Rich Text Format) code into plain text in Excel
  25. lastrow and excel table.
  26. How can I create text files with special characters in their filenames
  27. Open a workbook from VBA and disable Workbook_Open() code?
  28. How to filter listbox values based on a Textbox value
  29. How to have vba execute every 10 minutes?
  30. Read and write from/to registry in VBA

Leave a Comment