Greetings,

I have an enum that I use as a variable in a function. If I call on
the function from w/in the VBA IDE, the enum values are displayed, but
not when I call on the function from w/in Excel.

I have tried all sorts of things, but I am at my wit's end. Here is
the code...

Public Enum To_Unit
eMinute = 1
eHour = 2
eDay = 3
eWeek = 4
eMonth = 5
End Enum

Public Function ChangeUnit(Target As Range, ToUnit As To_Unit) As Long


Thanks in advance,
Jacob