Run-time error ‘1004’ : Method ‘Range’ of object’_Global’ failed

by

When you reference Range like that it’s called an unqualified reference because you don’t specifically say which sheet the range is on. Unqualified references are handled by the “_Global” object that determines which object you’re referring to and that depends on where your code is.

If you’re in a standard module, unqualified Range will refer to Activesheet. If you’re in a sheet’s class module, unqualified Range will refer to that sheet.

inputTemplateContent is a variable that contains a reference to a range, probably a named range. If you look at the RefersTo property of that named range, it likely points to a sheet other than the Activesheet at the time the code executes.

The best way to fix this is to avoid unqualified Range references by specifying the sheet. Like

With ThisWorkbook.Worksheets("Template")
    .Range(inputTemplateHeader).Value = NO_ENTRY
    .Range(inputTemplateContent).Value = NO_ENTRY
End With

Adjust the workbook and worksheet references to fit your particular situation.

More Related Contents:

  1. SumIf using Excel VBA
  2. How can I call a macro which contains a loop but only run one iteration of that loop?
  3. Test or check if sheet exists
  4. How can I find last row that contains data in a specific column?
  5. Copy from one workbook and paste into another
  6. How to copy Outlook mail message into excel using VBA or Macros
  7. Open Excel file for reading with VBA without display
  8. For Loop not fully cycling in excel VBA [duplicate]
  9. Excel VBA App stops spontaneously with message “Code execution has been halted”
  10. How to remove all non alphanumeric characters from a string except period and space in excel?
  11. Find last used cell in Excel VBA
  12. Does Dir() make any guarantee on the order of files returned?
  13. Call a Sub with a String
  14. How to clear memory to prevent “out of memory error” in excel vba?
  15. Assign on-click VBA function to a dynamically created button on Excel Userform
  16. Using a wildcard to open an excel workbook
  17. Faster way to remove ‘extra’ spaces (more than 1) from a large range of cells using VBA for Excel
  18. Extract Data from Word Document to an Excel SpreadSheet
  19. Excel macro -Split comma separated entries to new rows [duplicate]
  20. VBA equivalent to Excel’s mod function
  21. Get text from clipboard using GetText – avoid error on empty clipboard
  22. Benchmarking VBA Code
  23. Display milliseconds in Excel
  24. VBA editor auto-deletes spaces at the ends of lines
  25. Select entire column in table using Excel VBA
  26. Application.Quit command not closing the entire Excel Application
  27. Reducing WithEvent declarations and subs with VBA and ActiveX
  28. Trying to open the workbook in separate instance
  29. Function Overloading and UDF in Excel VBA
  30. VBA: Modify chart data range

Leave a Comment