James,

Months in VBA are the same as regular months, so 31.

But I'm guessing your question is somewhat more specific than it appears.

What kind of days? Workdays? Weekend days? Odd numbered Wednesdays?

HTH,
Bernie
MS Excel MVP

"james" wrote in message
...
hello,
What statement would I use to find out maximun days in a month in VBA?

Thanks in advance