Thank you for taking the time to read this and offer assistance.
Through searching various forums, I've discovered the code to determine the number of days in a given month when the date is in cell A1:
This works great when I enter the formula into another cell on the worksheet.
However, when I try to use it in a macro, I get a syntax error about a missing ")"...it wants it after the "Year" portion.
I've tried 2 different ways (Dim: UseDate as Date, UseDays as Integer, and DateVal as Integer)
1)
2)
Any solutions to be able to use this fine line of code in my macro?
Thank you -
Dan
Bookmarks