On Thu, 2 Apr 2009 09:30:47 -0600, salgud wrote:

On Wed, 1 Apr 2009 21:14:01 -0700, Jacob Skaria wrote:

D3 is already in the format ("mm-dd-yy") and that is the cause of error.

Either you can change it to
iServMonth = month(ws.Range("d3"))
Not sure what I would change to this.


OR

(as you have mentioned in your code)
iServMonth = Month(month(ws.Range("d3") & " 1,2009"))
Already have this in there, but it's not working.

The first one should be enough, right???
The first what should be enough?

Sorry, am not clear what you're suggesting.

I tried changing
iServMonth = Month(month(ws.Range("d3") & " 1,2009"))
to
iServMonth = month(ws.Range("d3"))

Still getting a type mismatch error