Hi,

See code below. When I run macro I get 'compile error: Sub or Function not
defined'. What am I doing wrong here?!

Regards,

Basta1980

Hi

You forgot to post the code.

Regards,
Per

"Basta1980" skrev i meddelelsen
...
Hi,

See code below. When I run macro I get 'compile error: Sub or Function not
defined'. What am I doing wrong here?!

Regards,

Basta1980

Per,

I'm sorry, still early morning here in the Netherlands;

MsgBox = datedif(a1, b1, "y")

Regards

"Per Jessen" wrote:

Hi

You forgot to post the code.

Regards,
Per

"Basta1980" skrev i meddelelsen
...
Hi,

See code below. When I run macro I get 'compile error: Sub or Function not
defined'. What am I doing wrong here?!

Regards,

Basta1980

In VBA the function is DATEDIFF() and not DATEDIF()

MsgBox DateDiff("yyyy", Range("A1"), Range("B1"))

If this post helps click Yes
---------------
Jacob Skaria


"Basta1980" wrote:

Per,

I'm sorry, still early morning here in the Netherlands;

MsgBox = datedif(a1, b1, "y")

Regards

"Per Jessen" wrote:

Hi

You forgot to post the code.

Regards,
Per

"Basta1980" skrev i meddelelsen
...
Hi,

See code below. When I run macro I get 'compile error: Sub or Function not
defined'. What am I doing wrong here?!

Regards,

Basta1980

On Wed, 19 Aug 2009 09:36:58 +0200, "Per Jessen"
wrote:

Hi

You forgot to post the code.

Regards,
Per


And here I thought I was going to read a pithy reply.