I am trying to setup a global constant variable for the current year using the date function, but I get an error" Compile Error - Constant Expression required". I am sure that must be in the way I am trying to do it. I want to be able to use the variable "CYear" in all the coding for my workbook instead of having to use the "Format(Date, "YYYY"). I have tried using the "Today(Now) formatting also without success. Here is what I have in Module1 with all of my other declarations:

Public Const CYear As String = Format(Date, "YYYY"):confused::confused:
I have the "Option Explicit" off and all help is appreciated.