Ok, I am trying to create a custom variable with data pulled from other variables but I can't get excel to accept it. I keep getting a type mismatch but can't figure out how to get past it
Public StartDate As Date
StartDate = "11/1/2010"
Dim Month As String
Month = DatePart("M", StartDate)...