Want a leading zero on a number
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
|