Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why would a vlookup function stop working in excel 2003? | Excel Worksheet Functions | |||
Conditional formatting: formula not working on other pc's | Excel Discussion (Misc queries) | |||
excel 2003 right-click function not working | Excel Worksheet Functions | |||
SendMail Function in Excel 2003 not working properly | Excel Programming | |||
CHR() function not working in Excel 2003 | Excel Discussion (Misc queries) |