Are you using Set to assign an object to your Months variable? For
instance

Set Months = Range("A1")

If you haven't declared Months to be an object variable, e.g.,

Dim Months As Range

then Months will by default be of type Variant. That's OK if you use
Set, but if not:

Months = Range("A1')

will assign the default property (here, .Value) to Months, rather
than the object itself.

This is a great reason to always use Option Explicit at the top of
your module and to declare each variable within your procedure.




In article ,
"Jeff" wrote:

After doing some trouble-shooting,
the problem is the & Months.value in the code. It does
not appear it is recognizing that for some reason