MOD function in VBA

[Dirk_Diggler]

Hi,

In the excel worksheet, I use MOD(YEAR();4) to determine whether there are 365 or 366 days in that year.

I would like to use this function also in my User Defined Function VBA Code.

I cannot find how to do this.

Thanks in advance for your tips.

Kind regards,

Dirk.

[Richard Buttrey]

Hi,

The VBA Mod functions takes the form

12 MOD 5

(which results in the value 2)

HTH

[shg]

Here's a way:

Please Login or Register  to view this content.

[Leith Ross]

Hello Dirk_Diggler,

Excel will incorrectly identify the year 1900 as a leap year. If you plan to test years for being leap years then you can use this formula for Georgian years starting with 1600 and onward.

Please Login or Register  to view this content.

[shg]

VBA does it correctly, Leith.

[Dirk_Diggler]

That worked out fine!

thank you for your help.

Kind Regards,

Dirk.