user1763769
Reputation: 103
getting compile error : Sub or Function not defined in vba when trying to use Today() function
I am getting compile error : Sub or Function not defined in vba when trying to use Today() function at below line :
Worksheets("Dashboard").Range("S" & row).Formula = WorksheetFunction.Days(Worksheets("Dashboard").Range("Q" & row), TODAY())
Upvotes: 0
Views: 876
Answers (1)
Related Questions
- Compile Error: Sub or Function not defined - Excel Function definition
- My Date Object is not compiling in my Subroutine
- How to fix Compile Error: Sub or function not defined in VBA?
- Excel Vba: Sub or Function not defined
- Compile error: Sub or function not defined
- With the code below I receive the error Variable not defined
- Compile Error: Sub or Function not defined in vba
- Compile Error, Sub or Function not defined
- Excel VBA: Compile Error: Sub of Function not Defined
- Excel VBA - Sub or Function not defined Error