‘1004’: “The sort reference is not valid.”

by

I suspect you need to fully qualify the Key1 range, because you are calling the code from a different sheet:

Worksheets("EmployeeData").Range("K3:K" & EmpBRange).Sort Key1:=Worksheets("EmployeeData").Range("K3:K" & EmpBRange)

This is generally a good idea.

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. Copy from one workbook and paste into another
  5. How to copy Outlook mail message into excel using VBA or Macros
  6. For Loop not fully cycling in excel VBA [duplicate]
  7. Unique Random Numbers using VBA
  8. Populate unique values into a VBA array from Excel
  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. Closing Excel Application using VBA
  12. How to clear memory to prevent “out of memory error” in excel vba?
  13. Assign on-click VBA function to a dynamically created button on Excel Userform
  14. Delete Row based on Search Key VBA
  15. How to add a button programmatically in VBA next to some sheet cell data?
  16. What are the benefits of setting objects to “Nothing”
  17. Using a wildcard to open an excel workbook
  18. How can I kill task manager processes through VBA code?
  19. VBA: Usage of parentheses for a method
  20. Fully reference a worksheet by codename
  21. OnTime for less than 1 second without becoming Unresponsive
  22. Get Unicode characters with charcode values greater hex `FFFF`
  23. How do I click a link on a web page using Excel VBA?
  24. Ping IP Address with VBA code and return results in Excel
  25. VBA copy cells value and format
  26. Select entire column in table using Excel VBA
  27. Create hyperlink to another sheet
  28. Reducing WithEvent declarations and subs with VBA and ActiveX
  29. Convert Early Binding VBA to Late Binding VBA : Excel to Outlook Contacts
  30. How to get the range of the visible rows after applying an advanced filter in Excel (VBA)

Leave a Comment