Ecniv,

I am just trying to use:

Dim myDateRange As Range
UserForm1.ComboBox1.Value = myDateRange

I defined the range using the insert/define bit on the menu bar.

I dont have a hidden column, at least not deliberately, and the date is currently formatted as: dd/mm/yyyy. Does any of that mean anything?