excel 2003 vba date function not working on all pc's
 

I use the date function in vba code and on most pc's it's working. However on
a few pc's it's enters break mode and the error message is "undefined
function and "date" is highlighted. ex: currentdate = date will give the
error but only on a few pc's.
thanks for any help

excel 2003 vba date function not working on all pc's
 

I'd start by looking for missing references on the problem pcs.

Inside the VBE with that project active
tools|References
Look for MISSING
if you find any, you'll have to decide if you need it or can just delete it.

If that doesn't work, ...

Look for subroutines/functions that are named Date.
Look for variables called Date.
Look for module names called Date.

(But I'm betting on the missing reference.)

Paul S. wrote:

I use the date function in vba code and on most pc's it's working. However on
a few pc's it's enters break mode and the error message is "undefined
function and "date" is highlighted. ex: currentdate = date will give the
error but only on a few pc's.
thanks for any help

--

Dave Peterson