Public Const declaration

[vidyanand]

Hello I want to declare public constant variable with following code

Public Const sheetname As String = Format(Date - 30, "mmm-yy")

It is giving compiling error 'Constant expression required'. I want to declare string variable which will store date in specific format. This variable value should change as month of the date changes. So could you please help me correct this error?

 

[mikerickson]

That is not a constant, it is a variable, different tomorrow than it is today.

You could cast that as a function. ("sheetname" is an odd name for a date value)

Function sheetname() As String
    sheetname = Format(Date - 30, "mmm-yy")
End Function

 

[vidyanand]

thanx mikerickson, corrected my mistake.