Excel error 1004 “Unable to get …. property of WorksheetFunction class” appearing inconsistently

by

This error occurs often when any argument passed to the worksheet function is not of the correct type or simply doesn’t make sense.

For example, I’ve had this problem when calling WorksheetFunction.Asin with an argument bigger than 1. In your case, I’d guess currentCell.Value is a non-numeric value or one not according to your region settings regarding numbers.

Yes, the error message is really misguiding.

More Related Contents:

  1. What is the difference between “Form Controls” and “ActiveX Control” in Excel 2010?
  2. filter out multiple criteria using excel vba
  3. How to use workbook.saveas with automatic Overwrite
  4. Cannot VBA write data to cells in Excel 2007/2010 within a function
  5. Find last row in range
  6. Excel: the Incredible Shrinking and Expanding Controls [closed]
  7. Excel VBA Run-time error ’13’ Type mismatch
  8. VBA Excel – IFERROR & VLOOKUP error
  9. How does one restore default case to a variable in VBA (Excel 2010)?
  10. Excel VBA Run-time Error ‘32809’ – Trying to Understand it
  11. SumIf using Excel VBA
  12. How can I call a macro which contains a loop but only run one iteration of that loop?
  13. How can I find last row that contains data in a specific column?
  14. Copy from one workbook and paste into another
  15. Open Excel file for reading with VBA without display
  16. How to remove all non alphanumeric characters from a string except period and space in excel?
  17. Find last used cell in Excel VBA
  18. Does Dir() make any guarantee on the order of files returned?
  19. Call a Sub with a String
  20. Assign on-click VBA function to a dynamically created button on Excel Userform
  21. Using a wildcard to open an excel workbook
  22. ADODB Connection String for .csv
  23. Removing special characters VBA Excel
  24. Excel macro -Split comma separated entries to new rows [duplicate]
  25. Get text from clipboard using GetText – avoid error on empty clipboard
  26. Display milliseconds in Excel
  27. VBA editor auto-deletes spaces at the ends of lines
  28. Application.Quit command not closing the entire Excel Application
  29. Trying to open the workbook in separate instance
  30. How to get the range of the visible rows after applying an advanced filter in Excel (VBA)

Leave a Comment