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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

index function in vba 3
Making all past dates bold, looping 2
VBA Code to delete duplicate and extraneous data 4
Access Dcount function in access 0
Can VBA Programs Run on a Locked PC 2
Excel 2000 VBA undefined function problem 1
VBA code 1
Excel Trying to code an Array Function in VBA Excel to works as a MaxIF 3

Back
Top