Retrieve last day of the month but hitting error

Thanks,

Solus

Please remember the following:

1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.

Highlight the code in your post and press the # button in the toolbar.

2. Show appreciation to those who have helped you by clicking below their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

"Slow is smooth, smooth is fast."